How to Create New Columns Based on Data Present in One .csv Cell

Hello All,

I have reports where one of the cells contains several "key/value" pairs. I'd like to create new columns where the keys from the cell will be column headers and the values will be listed beneath them.

Current data:

Form Response

Position - CSP;Role - IT Analyst;Practice/Office: - India;Region: - APAC;Contact name: - John Doe;Email: - johndoe@email.com;Vendor contact name: - TEST VENDOR;Email: - vendor@email.com;The fees shall be invoiced - Upon milestone;This SOW shall commence upon the (â€śEffective Dateâ€ť) hereof - 03/03/20;This SOW shall expire - 03/10/20

Desired output (Not all key/value pairs are included from the above cell. This is an example):

Position	Role	Practice/Office	Region	Contact name	Email
CSP	IT	India	APAC	John Doe	johndoe@email.com

I'm including a screenshot of a test document. I'm just beginning to learn Alteryx so any help is appreciated.

Thank you.

2020-03-23_12h20_44.png

Input

Output

Accepted answers

philipmannering

Hey David.

No worries. So I think you just needed to "Grop Data" in the Cross tab tool. This will carry those columns forward.

Take a look at the workflow attached and let me know if it's what you need.

key values to columns2.yxmd

All comments

philipmannering

Something like this should do the trick,

Philip

key values to columns.yxmd

gidHxly

Hello Philip,

Thank you very much for looking into this. I played around with it, but couldn't get the attached workflow to work with multiple columns of data. The logic I'm trying to put there is to use the 2nd column to generate additional column headers and also add values beneath them, and all subsequent columns should just add values, as headers are already created.
I'm including input file and output file with the desired look in the attachment. If it isn't too much to ask, would you please advise me on how to achieve that result?

Kind regards,

David

SoW Input.csv

SoW - Output.csv

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703