community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Generate rows based on periods in columns

Meteoroid

I need help on how to achieve this in Alteryx. Anyone that knows how?

Create table 2 based on table 1:

 

Table 1

Customer namePeriod 01 2019Period 02 2019Period 03 2019
A3,1468,5
B123

 

Table 2

Customer namePeriodValue
A01 20193,14
A02 20196
A03 20198,5
B01 20191
B02 20192
B03 20193
Alteryx Certified Partner
Alteryx Certified Partner

Hi @fredrikw you can use the transpose tool to produce the output you describeTranspose_130919.PNG

Meteoroid

Hi @JS420, thank you so much!

Alteryx Certified Partner
Alteryx Certified Partner

your welcome @fredrikw I amended the workflow slightly to remove period from the name column. 

Meteoroid

Your'e too kind, thanks!

Labels