Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Inserting column header for all files

Karthick461
8 - Asteroid

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

6 REPLIES 6
Luke_C
16 - Nebula

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
8 - Asteroid

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

 

1st input:

Karthick461_0-1659464155050.png

My Header:

Karthick461_1-1659464224629.png

Required Output is:

Karthick461_2-1659464280970.png

 

Emmanuel_G
13 - Pulsar

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.

Emmanuel_G_0-1659464170725.png

  

Emmanuel_G_1-1659464183142.png

Emmanuel_G_2-1659464346396.png

 

Luke_C
16 - Nebula

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. 

 

Luke_C_0-1659464548714.png

 

 

Emmanuel_G
13 - Pulsar

@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

Emmanuel_G_0-1659464771453.png

 

Karthick461
8 - Asteroid

Thanks Much @Luke_C . I got it now

Labels