Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Tranform CSV/Excel header value into a new column

Hi,

I have a source file coming as below with first 3 rows having the report details of topic, start time and other details.
Want to transform the topic from the row level and populate it as a column in dataset along with all the existing columns.(

the actual column headers are in row 6.)

I need the below marked which is Topic, start time and Report generated as new columns added and then remove  rows 1-5 after the tranformation.

 

 

we need the below marked which is Topic, start time and Report generated as column added and populated.

Need Help

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    4 years ago

    Hi Anonymous ,

     

    For this you need to add 3 new columns and they must have the following syntax:

    ReportGenerated Column

if [Column1] = "Report Generated:" then [Column2] else null

Topic Column 
if [Column1] = "Topic" then [Column3] else null

Vault Hour column
if [Column1] = "Vaul Hour" then [Column3] else null

     

    Next step is toNow just select each column right click and select fill down on each of the values and you will get a full column with the values you need then just delete the other rows and put the headers has needed.