Multiple Column Mapping

[kauser]

Hello,

i need to map one column from two different columns with two different conditions/rules. On output column i want to see if Item =AA then output column should be map from Number1 column and if Item=RR then output column should be map from Number2 column

Item	NUMBER1	NUMBER2	OUTPUT
AA	1234	4637	1234
RR	0987	2746	2746
AA	5678	2373	5678
RR	8765	4765	4765

[Qiu]

@kauser 
How would your output look like?
I believe we need a mapping input at least.

[KGT · Accepted solution]

IF [Item]="AA" THEN [Number1]

ELSEIF [Item]="RR" THEN [Number2]

ELSE Null()

ENDIF

If you have more than a couple options, then lookup table like @Qiu suggested!

[flying008]

Hi, @kauser 

FYI.

Switch([Item],Null(),'AA',[NUMBER1], 'RR', [NUMBER2])