Inserting column header for all files

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

Developer

Accepted answers

Luke_C

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.

New Workflow9.yxmd

Emmanuel_G

@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

Get header on correct field.yxmd

All comments

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.

Get header on correct field.yxmd

Luke_C

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.

New Workflow9.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317