community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Repeating Transpose

Highlighted
Atom

I am new to Alteryx , i have data in a CSV source file that is listed in repeating address format .  Every 4 rows is a  new record. I have tried to use transpose to convert with no luck - below is the input and desired output file.  Any assistance appreciated.

 

Alteryx.png

Alteryx Certified Partner
Alteryx Certified Partner
You could do this many ways but I would do this using two multi row formula tools and a cross-tab.

With the first multirow formula create a field called 'column' and use the statement....

IF [ROW-1:Column] = 4 THEN 1 ELSE [ROW-1:Column]+1 ENDIF

Then create a second multirow formula, this time calling the field 'Record' your statement this time will look like...

IF [Column] = 1 THEN [ROW-1:Record]+1 ELSE [ROW-1:Record] ENDIF

Then the cross-tab should be configured with the Record field as a group by field.

The column field show be your headers field and then the field with your actual data should be the values.

You can choose anyone of concatenate first or last was the modes as there will only ever be one value for each combination.

You can finally use a select tool to rename the fields.

Give this a try!

Ben
Atom

Ben thanks very much - your solution worked great .

Kris

Labels