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

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

3 REPLIES 3
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