Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

How to parse "tagged" values into columns

gioIezzi
5 - Atom

Hi Everyone!

 

I am trying to convert a data set from tags over to columns. I have already tried the transpose tool along other ones, but I'm only able to do it with 1 line. Whenever I try to add more than one line then it goes crazy!. 

 

This is how the data comes in:

NameJohn
Last NameDoe
Ammount120
NameLise
Last NameStuart
Ammount30
NamePablo
Last NameRamirez
Ammount85

 

 

 

This is how the data should look like:

Name Last NameAmmount
JohnDoe120
LiseStuart30
PabloRamirez85

 

 

Thanks in advance!

3 REPLIES 3
AngelosPachis
16 - Nebula

Hi @gioIezzi ,

 

You will have to create a field to group on before cross tabing your data. You can build this logic with a multi-row formula tool, to create groups of 3 records

AngelosPachis_1-1663945940974.png

 

 

AngelosPachis_0-1663945906834.png

Hope that helps.
Angelos

binuacs
21 - Polaris

@gioIezzi Another way of doing this with the tile tool

 

binuacs_0-1663949584666.png

 

Emmanuel_G
13 - Pulsar

@gioIezzi 

 

Find in attachement the way of doing that.

 

Please do not hesitate to mark this answer as solution if it helped.

 

Emmanuel_G_0-1663950077383.png

 

Labels
Top Solution Authors