Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
suppose I want to do a SQL condition using the formula inside the prepare recipe.
Query: ( ID IN (11,12,13) AND CITY NOT IN ('LA','NY','CA')) OR (ZIP NOT IN (111000,111011))
In formula language in Dataiku :
(arrayContains([11,12,13],'ID') {# for IN} && ---------???--------) OR (-------???-------)
what to write for 'NOT IN'?
Hi Pankaj,
You can use not() to have the opposite of a statement. In your case, evaluating that an array does not contain an element could be done with not(arrayContains(YOUR_ARRAY, YOUR_VALUE).
See more about boolean functions in Formula in the related documentation: https://doc.dataiku.com/dss/latest/formula/index.html#boolean-functions
You can also use directly ! : !arrayContains(YOUR_ELEMENT, YOU_VALUE)
Hope this helps!
Agathe