Multiple Column Mapping

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

Datasets

Developer

Developer Tools

Data Investigation

Accepted answers

KGT

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!

All comments

Qiu

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

0717-kauser.yxmd

KGT

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])

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703