Workflow help - how to compare outputs from Field infor and print missing column

[tomekgagola]

Hi, 

Just tried to compare to Field Infos and have a way to print results. How can I do?

Tom

[atcodedog05]

Hi @tomekgagola 

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

[tomekgagola]

Input attached.

Output it would be the list of the missing column(s) from the second input file. I just do not know how to compare the list from the top file to the bottom one to pick up the difference in columns.

Next step it would be to add any missing columns to file two (the bottom one) in dynamic way. 

[atcodedog05]

Hi @tomekgagola 

Here is how you can do it.

Workflow:

1. Using join to compare missing columns.

2. Using union tool to maintain same columns as top data.

Hope this helps : )