Creating New Fields Through Logic

[rsdhavle]

I have two fields RegionA and RegionB. I want to introduce a new field which will have logic like.

RegionA = 'ASIA' OR RegionB ='ASIA' ..I want this logic in new field lets say named RegionC. Will the above logic work for my scenario??

[Anonymous]

try like

Tab2:
LOAD * INLINE [
RegionA,RegionB,Revenue

ASIA,UK,100

ASIA,ASIA,200

UK, UK,300

US, ASIA,100
];


Load
RegionA,
RegionB,
If(RegionA='ASIA' or RegionB='ASIA','ASIA') as RegionC
Resident Tab2;

[rsdhavle]

This was helpful. I used this expression and in the region A and region b i passed variable based on RegionC field

RegionC field i created it in inline table so that i can use it as values in variables.

Thanks

[rsdhavle]

Can you tell me now this L2 + L4 condition i have to take in section access how can i take that? As if i pass L2 = Asia ,L4 = asia in section access table, it works as AND