Inserting column header for all files

[Karthick461]

Hi,

I am getting a file regularly which has data from the 1st row. No headers defined in those attachments. I have the header row separately , which will not change.

Now I need to insert one blank row on top of my dataset and add the header value on that blank rows.

Tried with Union function, but its not working

Is there any way to achieve this please

[Luke_C]

Hi @Karthick461 

You should use the dynamic rename tool. It will allow you to feed in the headers you have separately stored. Give it a go. If you can't get it to work attach some sample data.

[Karthick461]

@Luke_C I tried Dynamic Rename. But its changing 2nd row. 1st row not changing. here is my dataset

1st input:

My Header:

Required Output is:

[Emmanuel_G]

Hi @Karthick461 ,

It's possible with union.by using auto config py position or manually configure fields ( Screenshoot 2 ) and by setting the output order ( Screenshoot 1 ).

Find the details in workflow attached.

[Luke_C · Accepted solution]

Hi @Karthick461 

Here's an example of how it works. If I had to guess, you're importing an excel and you should check the box in the input tool for 'first row contains data'. 

I'm afraid you'll have to provide some more information otherwise. 

[Emmanuel_G · Accepted solution]

@Karthick461,

Use Union with Auto config by position. So the first header will be above the first field, the second header above the second field and so on.

And put the input connection of header above as below

[Karthick461]

Thanks Much @Luke_C . I got it now