Splitting One Record into Two and adding Labels

neuling

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:

Order	Operation short text	Actual work	Planned
70030059	XYZ	111.9	80.0
70030059	ABC	6.2	28.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): 

Order	Operation short text	Hours	Version
70030059	XYZ	111.9	Actual
70030059	XYZ	80.0	Plan
70030059	ABC	6.2	Actual
70030059	ABC	28.0	Plan

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

Screenshot.PNG

Alteryx Help Transform File.xlsx

robdelisle

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.

-Robert