ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community has implemented a new single sign-on experience. If you are having issues with your account, please review the FAQ's.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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