Dynamic Headers Rename

[DataPirate26]

Hi all,

I want to rename the Headers to their Original Names. But facing some challenges in 6 of the rows not getting mapped properly to the actual header names. Can you fix the issue ?

Below Attached is the sample data and the actual headers. 

Also I have attached the issue that I am getting. Check from 36-41 row. 

[stataltgee]

@DataPirate26  try using record ID tool to give a unique ID to each row. Let me know if that works.

[DataPirate26]

@stataltgee Hi Already did that. If you can see the issue is in row no 36-41. I am not able to Map those few Lines. That is the main challenge. I have attached it for reference. Can you please provide a solution for reference 

[Qiu]

@DataPirate26 
I assume that you want to restore the orignal order and name of fileds after cross Tab.

I normally introduce approach like below.

Tile tool will provide sequence as order of the orginal fields, so the order of fields can be kept.

Then use Dynamic Rename to replace the orgina name of fields.

[DataPirate26]

@Qiu Sorry but this solution didn't work. The Data I have provided Is after cross tab. The Actual Headers also I have provided. Can you guide me to Map it by a different appraoch. 

I have only issue in Line 36-41. Not sure how to fix that

[stataltgee]

@DataPirate26  I would suggest just remove the "_" from cross tab and "-" from actual headers. Then sort. Attaching image for reference.

[Qiu]

@stataltgee 
I was thinking the same 😁

[flying008]

Hi, @DataPirate26 

Another way for you: