Dynamically Rename First Column

[elamp6]

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?

[Inactive User · Accepted solution]

Dynamic Rename. Use Formula option. Check Dynamic/Unknown Fields. Then set a hard coded value for it.