compare two files, old vs new column mapping.

Question

Hi,

I want to compare two files.

File A and File B has new columns mapped, like so:

OldNewField1  Field2user1 Field3 user1Field4 Field5 Field6  Field7  Field8  Field9  Field10 user1Field11  Field12  Field13user1user1Field14user1user1Field15user1user1Field16user1Field17 Field18 user1

However 'old' file - can also have duplicates.

How can I compare these two files? I want to make sure they are covered the same.

Biswarun · Answer

Please share a minimal reproducible example in an easy-to-understand language. For example, I cannot understand why some of the cells in your dummy table are filled with "User1" while the rest are blank. Have you come across the dynamic rename tool?