Alteryx designer Discussions

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

table conversion to MATRIX

Highlighted
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

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

Highlighted
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

Highlighted
6 - Meteoroid

Thx bro

Labels