topic Re: Need to filter excel data in load editor in App Development

Need to filter excel data in load editor

arvsuri007 — Fri, 06 Sep 2019 12:31:42 GMT

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

wade12 — Fri, 06 Sep 2019 12:51:45 GMT

perhaps you might experiment with where exists and/or where not exists.

arvsuri007 — Fri, 06 Sep 2019 14:07:46 GMT

I tried but "where" condition is not working. 😞

wade12 — Fri, 06 Sep 2019 14:12:09 GMT

it should be "where exists"

open the example & results section in this link: