Alteryx Designer Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

table conversion to MATRIX

Bordin_Wanichodom
6 - Meteoroid

dear all alteryx users,

I would like to convert the table here below into matrix form

Table form:

Bordin_Wanichodom_0-1575451552623.png

 

Matrix form:

Bordin_Wanichodom_1-1575451710779.png

 

highly appreciate all support

DanielMS
Alteryx
Alteryx

Hi @Bordin_Wanichodom ,

 

You can do this by using the cross-tab tool in the transform category.

 

DanielMS_0-1575452664376.png

 

In the configuration of the tool you will need to:

- Group by Company

- Set New Headers as Transportation

- Set Values to Frequency

- Choose the Sum aggregation method

 

Kind regards,

 

Dan

wdavis
Alteryx
Alteryx

Hi @Bordin_Wanichodom 

 

As @DanielMS said, the Cross-Tab tool can easily achieve this for you.

 

See attached workflow for the configuration you can copy to your workflow.

 

Thanks

Will

Bordin_Wanichodom
6 - Meteoroid

Thx bro

Labels