Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

table conversion to MATRIX

Highlighted

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

Highlighted
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

Thx bro

Labels