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

Question

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

Book1.xlsx

Yoshiro_Fujimori · Answer

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

CompareFields.yxmd

StellaBon · Answer

@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".