Reconciling between 2 columns and generating results next to it

[skotian1289]

Hello All,

I am trying to create a workflow which will reconcile 2 columns and add results next to it, I do not want to use formula tool because I don't want to write seperate expression for each set of columns and then move the results column using select tool post that. Is there an alternative which can help with below output.

Data:

Column A   Column B   Column C    Column D   Column E   Column F
   X                    X               Z                  X                  Y              Y
   Y                    Y               Z                  Z                  Y               X 

Expected Results:

Column A   Column B   Results     Column C    Column D    Results      Column E   Column F    Results
   X                   X           TRUE             Z                   X            FALSE          Y               Y              TRUE
   Y                   Y           TRUE             Z                  Z             TRUE            Y               X              FALSE

SK

[CKP · Accepted solution]

Hi @skotian1289 

This is a bit longwinded but I believe it gets to the result you're looking for.

I hope this helps.

[skotian1289]

Apologies I am a new user  ,any ideas would be welcome, because I am stuck currently in figuring out the solution.

Regards,

SK

[skotian1289]

Hi @CKP ,

Your solution is what I was looking for, though it took me time to understand each and every step and how it came to the solution but it was bang on. Thank u so much.

SK