Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
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
binu_acs
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

binu_acs
21 - Polaris

@AltExplore Are you using excel as an input file?

AltExplore
7 - Meteor

@binu_acs 

 

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

binu_acs
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

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

binu_acs
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