workflow for comaring files

Question

Hello Community,

I am trying to build a workflow which could compare files with different column schemas, which means that we have file A, file B, file C... and each file has version 1 and version 2. I would like to create comparison reports for each file (A, B, C...) which illustrate the difference between version 1 and version2.

I want to achieve this by using batch macro. But during comparison (I used join for comparison), since each file has different column schemas, I am not able to choose the correct columns for comparison.

Any help will be appreciated!

Thank you very much in advance!

mbarone · Answer

I see.  Assuming you can get the full paths to each pair of files, you'd have to read those into a batch macro.  The batch macro itself could transpose the file so you get two columns: name/value.  And then you can join on the name/values.  Check out the Transpose tool and try it with a couple files.  That might be what you're looking for.

Alteryx_2021 · Answer

Hi mbarone,

actually I am going to compare the content of the files. For each comparison, two files have the same schema. But I have files of different column schema that need to be compared.

Best

mbarone · Answer

Are you just trying to compare schema, meaning field names/size/types, etc?  In that case, you can use the Field Info tool on the Developer Palate and join on all those atttributes.