Alteryx designer Discussions

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

Data Table Transfromation

Highlighted
Atom

Hi, 

I have a data table with multiple headers and I intend to transform the data to look like the photo attached. 

I have trouble generating repeating rows for the headers which is where im currently stuck at. 

The data i start with looks like this: 

Capture1.PNG

 

 

and I would want the data to have this layout:

Capture2.PNG

(with the values instead of null).

Can anyone guide me in the right direction? Thank you very much! 

Alteryx
Alteryx

Hi @csprch,

 

I have attached a workflow that solves your problem.

 

Thanks

 

Dan

Highlighted
Alteryx
Alteryx
 
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @csprch I mocked up a workflow that produces the output you describe. Not the most clean solution but let me know what you think?

Highlighted
Alteryx
Alteryx

Seeing as I started as well and then got distracted I too built it out.

 

DataSwap.png

Labels