topic Re: How to use 'Equal to' in set expression? in App Development

How to use 'Equal to' in set expression?

Karahs — Fri, 22 Apr 2016 06:59:29 GMT

hi,

Could you please let me know how to use “equal to” in the set expression.

eg. I have a region column and wana take only those region which i want to see in the list . How do i do that?

eg. for NOT EQUAL we use '<>' so for EQUAL what we can use in set expression?

Thanks

sunny_talwar — Fri, 22 Apr 2016 09:06:03 GMT

I would just do like this:

{<Region = {'Region1', 'Region2', 'Region3'}>}

Karahs — Mon, 25 Apr 2016 04:52:50 GMT

Hey ,

I tried putting this expression but it isnt working..Can u tell how to use it in Load editor using a where clause?

sunny_talwar — Mon, 25 Apr 2016 15:27:22 GMT

In the load script, you can try this:

LOAD YourFieldNames,

FROM

Where Match(Region, 'Region1', 'Region2', 'Region3');

Anonymous — Mon, 25 Apr 2016 15:28:39 GMT

Hi,

In editor , you can write like this ...

But for the SET EXPRESSION what sunny said should be correct !!!!

LOAD * INLINE [

Country, Total Debt, 0-60, 60-180, 180+

USA, 152, 123, 23, 6

Canada, 250, 100, 100, 50

UK, 170, 170, 0, 0

Germany, 190, 0, 0, 190

Japan, 90, 15, 25, 50

France, 225, 77, 75, 73

]

Where(Country='USA');