Start Free Trial

Alteryx Designer Desktop Discussions

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

Change the header in the workflow

AhmedYousry98
5 - Atom

I have small issue as I am collecting the data from google sheet and the input data does not have the option to skip the first row in the sheet. So I need to remove the row that contains field_72 etc.. and make row 1 a header in the workflow.I do not want to rename them manually because there many columns 

4 REPLIES 4
Felipe_Ribeir0
16 - Nebula

Hi @AhmedYousry98 

 

Use the dynamic rename tool to take the field names from the first row

 

Input

 

Felipe_Ribeir0_1-1667738774658.png

Output

 

Felipe_Ribeir0_0-1667738731511.png

 

Emmanuel_G
13 - Pulsar

@AhmedYousry98 

 

Use dynamic rename to take this first row as header dynamically.

 

Emmanuel_G_0-1667738855245.png

 

 

 

AhmedYousry98
5 - Atom

Thank you very much it worked 

AhmedYousry98
5 - Atom

Thank you very much for helping 

Labels
Top Solution Authors