Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Discussions

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

Correlation between products and creation of a heatmap using the correlation matrix

8 - Asteroid

using the field name "Category Name" i want to establish if there is a correlation between the various products.

This is to help come up with a pearson correlation matrix and then product a heatmap analysis, the heatmap analysis is to help depict closely related products to help with product recommendation.


Closely related products(with a high correlation e.g 0.7) are to be recommended.

Attached is the data extract with the dump, main focus is on "Category name"




14 - Magnetar

Is this what you are looking for? You also might want to look at the Market Basket tools.

8 - Asteroid

Thanks @gabrielvilella this works well, much appreciated!