compare two files, old vs new column mapping.

[wonka1234]

Hi,

I want to compare two files.

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

	Old	New
Field1
Field2	user1
Field3		user1
Field4
Field5
Field6
Field7
Field8
Field9
Field10		user1
Field11
Field12
Field13	user1	user1
Field14	user1	user1
Field15	user1	user1
Field16	user1
Field17
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]

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?