If Statement

[Pomna]

I have data like the table below. I need to write a set expression or load flag which says

if  Location ID of IssueReporter = 10003 then Texas

Thanks

[ArnadoSandoval]

Hi @Pomna 

You database should have a table with a Locations table, if you load this table, associate its index column with the Location ID column, you may not need to introduce any IF statement, but if you still have difficulties consider introducing a mapping table sourced from the Locations table and implement an ApplyMap()

Hope this helps

[PrashantSangle · Accepted solution]

a simple if statement work for you

if([location id]='10003','Texas')

is this you are looking for.? ?? if not then can explain your query in detail, with sample data and expected output..

Regards,

Prashant Sangle

[Pomna]

Thank you. It worked as expected