Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Turn header into regular row

jcornale
7 - Meteor

I want to turn a header row into a regular row. For example:

 

Capture.PNG

 

 

4 REPLIES 4
jdunkerley79
ACE Emeritus
ACE Emeritus

Easiest way I can think of is to use a Multi Field Formula to get Name and store as value remembering to change field type and to not create new fields.

 

Then union onto data.

 

2018-01-04_15-54-27.jpg

 

Sample attached

danrh
13 - Pulsar

Another option, using the Field Info tool:

image.png

EmanueleE
8 - Asteroid

Hi @jcornale,

 

I had fun solving this problem without "Join" Tool.

 

resultresult

generate rowsgenerate rows

multi fieldmulti field

Boneckrh19
5 - Atom

Danrh, my version of Alteryx is too old to open your file; could you tell me what you put in Record ID and Cross Tab?

Labels