Comparing outputs of two groupby statement to create a new column

[sriniprad08]

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" 

Thanks,

Sri

[Yoshiro_Fujimori · Accepted solution]

Hi @sriniprad08 ,

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

Workflow

Output

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]

Hi @Yoshiro_Fujimori ,

Thank you very much for the help .Appreciate it.

Cheers,

Sri