We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Comparing outputs of two groupby statement to create a new column

sriniprad08
11 - Bolide

Hi Team,

Hope you are doing well.

I need help. Can you please help where i have to create 

1) Two Outputs (A and B)

2) Compare output A and output B to create a new column with "match" or not "match". Including the "Total" 

sriniprad08_0-1686984363641.png

 

Thanks,

Sri

2 REPLIES 2
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

Hi @sriniprad08 ,

 

Here is one way of doing this. I hope this helps.

 

Workflow

Yoshiro_Fujimori_0-1686988429652.png

 

Output

Yoshiro_Fujimori_1-1686988453158.png

 

Formula tool for matching

Final Output = 

IF    [Output A saj] = [Output B saj]

  AND [Output A tke] = [Output B tke]

THEN "Match"
ELSE "Mismatch"

ENDIF

 

sriniprad08
11 - Bolide

Hi @Yoshiro_Fujimori ,

 

Thank you very much for the help .Appreciate it.

 

Cheers,

Sri

Labels
Top Solution Authors