Alteryx designer Discussions

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

Create new columns with multirow data cross tab

Highlighted
7 - Meteor

Hi , 

 

I am trying to create new columns using the cross tab functionality however I am not able to achieve the desired results. I am not sure if I am missing some steps here but this is the situation. I have the following dataset

 

Fields.NameFields.Types.Name
String 1Type 1
String 2Type 2
String 3Type 3
String 4Type 3

 

I want to get the following after the Alteryx operation: 

 

Type 1Type 2Type 3
String 1String 2String 3
  String 4

 

During the cross tab operation, i am only able to concatenate all the strings into 1 single row and hence not able to achieve the desired table above. 

 

Any help will be much appreciated!

Alteryx Certified Partner
Alteryx Certified Partner

Use a Tile tool (set to "Unique Value") to assign a sort of "grouped RecordID" field before performing the CrossTab and you're all set.

 

20191121-TileCrossTab.png

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @YanishDewan ,

 

assign a Id to the "Fields.Name" by group (e.g. using Multi-Row Formula tool), it should be no problem then.
See attached workflow.

 

Regards

 

Roland

Labels