Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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