Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Splitting One Record into Two and adding Labels

Highlighted
5 - Atom

Hi all,

I am new to Alteryx. I get a report from SAP that has a more or less fixed format. The data are line items of actual hours worked versus planned worked hours by order:

 

OrderOperation short textActual workPlanned
70030059XYZ111.980.0
70030059ABC6.228.0

 

I would like to parse the data so that there is only one column for hours worked, plus a new, "version" column to mark each line as plan or actual (below): 

 

OrderOperation short textHoursVersion
70030059XYZ111.9Actual
70030059XYZ80.0Plan
70030059ABC6.2Actual
70030059ABC28.0Plan

 

Does anyone know the right functions to achieve this? Thanks in advance!

Highlighted
7 - Meteor

Hello,

 

You will want to use the transpose tool which will take your table from being wide to long. Conversely, you can use the crosstab tool to take your data from a long table to a wide table.

 

TRansposeTool2.png

 

-Robert

Highlighted
5 - Atom

Thank you! I knew it had to be simple.

Labels