Reconciling between 2 columns and generating results next to it

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

Accepted answers

CKP

Hi @skotian1289

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

Reconcile 2 columns.jpg

I hope this helps.

Reconcile 2 columns.yxmd

All comments

CKP

Hi @skotian1289

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

Reconcile 2 columns.jpg

I hope this helps.

Reconcile 2 columns.yxmd

skotian1289

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

Regards,

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703