I'm trying to complete th task of moving the header of a column (which contains data) down and adding a new header:
Here is my current data using the browse tool. I need the header "1 ;3;498;1.75 ;4" to become a record and then create a new header. I was able to use the dynamic rename tool to rename the header but I need to retain that data instead of just renaming it.
Solved! Go to Solution.
In your dynamic input tool, click edit on your input template, scroll down and make sure to check the box that says first row contains data. This will give you generic column names like Field1, Field2, etc... but more importantly it won't use your data as column names.
Wow! Something so simple that I missed. lol Thank you adm510