Alteryx designer Discussions

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

How to transform data into columns

Highlighted
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) 

 

Highlighted
Alteryx Certified Partner

Hi @Chelsead ,

 

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

 

Thanks,

Fernando Vizcaino

Highlighted
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?
Highlighted
Atom

Thanks! ive uploaded an extract 

Highlighted
Alteryx Certified Partner

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

Highlighted
Atom

Attached a snip  

Highlighted
Alteryx Certified Partner

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