How to transform data into columns

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)

Capture.PNG

Alteryx Extract.xlsx

Workflow

Accepted answers

fmvizcaino

Hi @Chelsead ,

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

Thanks,

Fernando Vizcaino

fmvizcaino

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

data into columns.yxmd

All comments

fmvizcaino

Hi @Chelsead ,

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

Thanks,

Fernando Vizcaino

BrandonB

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

Thanks! ive uploaded an extract

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703