Workflow Help

Hello,

Help needed on reconciling BB to AA based on quantity and character. The reconciliation will be on a 1/1, 1/multiple, multiple/multiple basis. The unique key identifying both sides is the ID. The output file should only have matching values. Thank you!

Workflow

Accepted answers

Here is the sample workflow for your case. Hope this is helpful.

Workflow Output1 Output1 Output2 Output2 Output3 Output3

Workflow help3.yxmd

Attaching updated workflow. Hope this is what you are looking for.

Workflow Results Results

Workflow help3 (1).yxmd

All comments

Possible to share sample output ?

Please find attached sample output. It should only return date and character for BB matching AA. Thanks!

Sample output.xlsx

Here is the sample workflow for your case. Hope this is helpful.

Workflow Results Results

Workflow Help.yxmd

HI Ponraj,

Thank you for your input! Can you please explain to me why you chose to use the cross tab tool?

Quick Links

Tags

This months top contributors

AkimasaKajitani 388

Hollingsworth 335