Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Column Name Changes Every Refresh

The excel dataset I am importing has the date and time for when the dataset was created in cell A1.  There are two blank rows below it, then in row 4 are all the column names, and then the actual dat...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

I had a similar question answered on this type of error on as previous post but don't remember the address basically you can do the following before promoting headers:

  • Add an index column
  • Add a calculated column with the following code:
if  [Index] = 1 then "Date" else [CustomColumn]
  • If your index starts at 0 replace the 1 and use replace the "Date" by the name you need on the column the custom column is the one that were you have hard coded the date

Now delete the other custom column and the index column do the promote headers.