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
20 - Arcturus
20 - Arcturus

@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