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