Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to filter data with unique values from my data set. I have made an expression just to filter out data in load editor.
If(datafield= peek(datafield),1,0)
I want to use an expression to filter data with value '1' in load editor. Please help.
Regards,
Arvind
perhaps you might experiment with where exists and/or where not exists.
I tried but "where" condition is not working. 😞
it should be "where exists"
open the example & results section in this link: