When I import my data each month, the first cell in the first column is the date (obviously the date changes each month) and I need to dynamically replace this date with a column title.
04-03-19 | ColumnTitle2 | ColumnTitle3 | ColumnTitle4 |
ID1 | data | data | data |
ID2 | data | data | data |
... | data | data | data |
ID12345678 | data | data | data |
Any ideas on how I can go about accomplishing this?
Solved! Go to Solution.
Dynamic Rename. Use Formula option. Check Dynamic/Unknown Fields. Then set a hard coded value for it.