if condition

[raadwiptec]

is it possible to have like an if condition as below

if(match(country name, then A and B else C

A

B

C  are 3 different values in one table.

[sunny_talwar]

So basically if the Country name is France, you want to create two rows for it... one with the value Legal and the second one with processed?

May be try with link table

LinkTable:

LOAD DISTINCT [Country name],

     If([country name] = 'France', 'Legal', 'unauthorized') as Flag

Resident ....;

Concatenate (LinkTable)

LOAD [country name],

     'processed' as Flag

Resident ...

Where [country name] = 'France';