Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to transform data into columns

Chelsead
5 - Atom

Hi All, 

 

New to alteryx and need some help choosing which tool can help me with the following: 

 

How to transform the data into separate columns showing the value (Number) for each area type (Warehouse, office, factory, Total) 

 

6 REPLIES 6
fmvizcaino
17 - Castor
17 - Castor

Hi @Chelsead ,

 

Is it possible for you to share that data in an excel for me to build an example?

 

Thanks,

Fernando Vizcaino

BrandonB
Alteryx
Alteryx
It looks like the first step is to split your data using a text to columns tool and using a semicolon as a delimiter. Could you provide an example of what you would like your output to look like?
Chelsead
5 - Atom

Thanks! ive uploaded an extract 

fmvizcaino
17 - Castor
17 - Castor

Hi @Chelsead ,

 

See if this works for you! 🙂

 

If this is what you are looking for, please mark the post as a solution, please 🙂

 

Best,

Fernando Vizcaino

Chelsead
5 - Atom

Attached a snip 🙂 

fmvizcaino
17 - Castor
17 - Castor

Hi @Chelsead ,

 

I'm not sure you have checked my solution in the post before, since we post a response at the same time.

I think I achieved what you were looking for! 

 

Glad to help you.

Best,

Fernando Vizcaino

Labels