Compare two separate excel files and report on matched and unmatched column name

Hi @mackmk

First - The Xls Reader ( master ) insert on Workbench, but after choose the Parameters -> Field Names Row = 0:

And expose the format Attribute from xls file = xlsx_row_id.

Use the transformer Tester to filter just the Line 1. If you check the Output Port Passed ( after Run ) you can see the values from Attributes A and B.

Second - Input the files from your customer with the same operation above ( that I described ) and use a transformer to compare these values, for example FeatureMerger.

If you need more some help, don't hesitate to describe here.

Thanks,

Danilo

Hi Danilo - Thanks for your response.

How should I use FeatureMerger - if I use a form id/any column as a joiner(join on) - it would merge all the features...

Thanks,

Mak

Hi @mackmk

You can use with concatenation attributes:

Thanks,

Danilo

I would use the Schema Reader, instead of an Excel reader.

The Schema reader only passes the column names to the workspace, not the data.

Then compare the schema's using the ChangeDetector transformer, to see if the schema's match.

@danilo_fme, @erik_jan Thanks for your replies. I have tried the suggested options but did not get the desired results - not sure if I have set it up right... I have attached the two excel files containing the column names - could you please assist with the workflow?Table1_SourceFile.xlsxTable2_ComparisonFile.xlsx

@danilo_fme, @erik_jan - I think I got it working -this is how it looks now(re snapshot) - used the schema reader, listExploder & FeatureMerger to get the desired outcome - Thanks heaps for your help.