Alteryx designer Discussions

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

Create columns based on values of a specific column

Highlighted
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  
ACE Emeritus
ACE Emeritus

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!

Highlighted
5 - Atom

Thanks a lot, this solved it perfectly!

Labels