In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Merging top 2 rows to make a header

AliceG
5 - Atom

Hi there, 

 

I have survey data where the top row is the question number and the 2nd row is the question text. I'd like to merge them into one header showing question number&". "&question text. 

 

How can I do this?

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@AliceG 
Maybe we can do something like this?

0331-AliceG-1.PNG0331-AliceG-2.PNG

AliceG
5 - Atom

Brilliant, it works perfectly thank you.

AliceG
5 - Atom

Quick addition if someone else needs this.

 

I also added a record ID tool before the summarize tool and a sort tool after the summarize tool to sort by record ID, then select tool to take out the Record ID. 

 

Because the summarize tool automatically orders by Name and I have more than 10 questions the order becomes 

Field_1

Field_10

Field_11

etc. 

 

instead of

Field_1

Field_2

Field_3

etc. 

 

AliceG_0-1648772995795.png

 

Labels
Top Solution Authors