How to Map table in alteryx to compare fields in excel?

[joshikalyani]

Hi,

I'm trying to map a table in my alteryx workflow, There are 2 different files, compare perticulat columns named differently.

e.g. There are 2 files A & G

File G has Column "type" to compare with File A has column "Trade Description".

But the values are differently mentioned in both files.

Mapping Table attached, so, if G file has column Type value as "REPO" & File A has column  "Trade Description" values either "Repo" or "ReverseRepo" then "TRUE" else " FALSE"

I tried with If else statement but not working as expected.

Attached File & Mapping Table for reference

[StellaBon]

@joshikalyani 

If [A] = "Repo"

OR [A] = "ReverseRepo"

AND [G] = "REPO" 

THEN "TRUE"

ELSEIF ....(Continue with other conditions structured as above)

ELSE "FALSE"

ENDIF

Pay attention to the logic of your "AND's" and "ORs".

[Yoshiro_Fujimori]

Hi @joshikalyani ,

If you want to check the existence of the combination of names of A & G against the input data, I would use Join tool.

Workflow

Configuration of Join tool