Request help with applying logic in Alteryx

Question

Hi All,

I have a dataset with the input data in Column A and Column B. I want alteryx to compare both the results and apply the results as per column C by creating a new column.

The alteryx need to apply a result as per column C if both COlumn A and COlumn B are matching.

I have tried with FInd replace tool but failed. Please help.

Mapping FIle - Copy.xlsx

duttaabhishek · Answer

Hi ... sorry about that....

Actually in the excel the Column A and Column B is the Input dataset. And column C is the Expected Result (Output).

I want alteryx to Check column A and Column B and if both the condition satisfies within a Row it will display the result as per column C.

usmanbashir · Answer

@duttaabhishek - Please see attached workflow. In the workflow, you'll see that I included your input file twice. I did that replicate a scenario where you don't have the expected output yet. Then you map accordingly to get your expected field. Hope this helps!

DataMapping.yxzp

Matt_D · Answer

@duttaabhishek  as above, I cannot work out your logic.  What for instance determines row 6 to be China, rows 31 & 32 to be INTERNATIONAL HUB, etc. You say "matching" but what is meant to match?