Coming soon: We’re working on a brand new, revamped Community experience. Want to receive updates? Sign up now!

0 votes
Hi,

I have user case where I have defined a variable like

PHONE: "'iPhone','Samsung Galaxy'"

I am writing a case statement like

when device type in (S{PHONE}) then 'PHONE'

I want to use the variable name itself in the case statement if possible. Could you please let me know if possible ?
by

1 Answer

0 votes

Hi, 

You can do variable expansion in SQL with the syntax ${variable_name}, as stated here: https://doc.dataiku.com/dss/latest/advanced/variables_expansion.html#pig-sql

Cheers,

 

by
1,337 questions
1,362 answers
1,556 comments
11,912 users

©Dataiku 2012-2018 - Privacy Policy