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

Create columns based on values of a specific column

md666
5 - Atom

Hello,

I want to prepare my data for advanced analytic and need to transform my data but could not find a solution yet.

Data looks like:

UserIDTestValueUnit
1A3.0dl
1B2.0cm
2A1.0dl

 

Results should look like this:

UserIDTest A ValueTest A UnitTest B ValueTest B Unit
13.0

dl

2.0cm
21.0dl  
2 REPLIES 2
Claje
14 - Magnetar

Hi,


I think you can accomplish this with a Transpose tool and a Cross Tab tool.  I've attached a workflow that I believe accommodates this transformation.

 

Hope this helps!

md666
5 - Atom

Thanks a lot, this solved it perfectly!

Labels