How to use 'Equal to' in set expression?

[Karahs]

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]

I would just do like this:

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

[Karahs]

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 · Accepted solution]

In the load script, you can try this:

LOAD YourFieldNames,

FROM

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

[Anonymous]

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');