Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Combine Header rows

AltExplore
7 - Meteor

Hi Team,

 

My header row which is an export and connection to excel has 2 rows instead of 1. Is there a way I can combine this on the file import.

 

AltExplore_0-1670253729707.png

 

Result Desired :

AltExplore_1-1670253896295.png

 

Thanks in advance

7 REPLIES 7
binuacs
21 - Polaris

@AltExplore One way of doing this

binuacs_0-1670254233437.png

 

AltExplore
7 - Meteor

@binuacs

 

Thanks the table then contains data on the next 100 rows. I am running into some issues.

 

Please refer to the attached

binuacs
21 - Polaris

@AltExplore Are you using excel as an input file?

AltExplore
7 - Meteor

@binuacs 

 

Yes for now but later will be accessing directly from DB, then I may not have this issue. But first I need to concat first 2 rows as header

binuacs
21 - Polaris

@AltExplore If you are using excel as input then select the option in the input tool 

binuacs_1-1670256623155.png

 

 

 

binuacs_0-1670256515320.png

 

AltExplore
7 - Meteor

@binuacs Seems you are using a newer version of Alteryx and unable to open this file..thanks

binuacs
21 - Polaris

@AltExplore I am attaching with workflow

 

Please let me know if you are able to open the workflow or not. Attaching the excel input file i  used

Labels
Top Solution Authors