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: NameJohnLast NameDoeAmmount120NameLiseLast NameStuartAmmount30NamePabloLast NameRamirezAmmount85 This is how the data should look like: Name Last NameAmmountJohnDoe120LiseStuart30PabloRamirez85 Thanks in advance!

How to parse "tagged" values into columns

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:

Name	John
Last Name	Doe
Ammount	120
Name	Lise
Last Name	Stuart
Ammount	30
Name	Pablo
Last Name	Ramirez
Ammount	85

This is how the data should look like:

Name	Last Name	Ammount
John	Doe	120
Lise	Stuart	30
Pablo	Ramirez	85

Thanks in advance!

Datasets

Input

Output

Parse

Best Practices

Transformation

Preparation

Accepted answers

AngelosPachis

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

Hope that helps.
Angelos

sample_workflow.yxmd

All comments

AngelosPachis

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

Hope that helps.
Angelos

sample_workflow.yxmd

binu_acs

@gioIezzi Another way of doing this with the tile tool

Arrange_0923.yxmd

Emmanuel_G

@gioIezzi

Find in attachement the way of doing that.

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

How to parse.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703