We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

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

Need help creating matrix like this.

stevenlsj789
8 - Asteroid

stevenlsj789_0-1634188688538.png

In this attachment below, I have a large joined file in the current file format and we wanted to create a matrix format in the goal session. Right now I am manually adding all the prices together to create this matrix in the attachment below. I would greatly appreciate it, if someone can help me create a sample workflow for this. 

 

Thank you!

 

 

2 REPLIES 2
mst3k
11 - Bolide

just need to use the crosstab tool, which has a built-in sum formula. now, you also want to add together the price1 and price2 in your row, because crosstab will only sum up a single column and you're essentially trying to sum together 2 columns. 

the multifield tool just converts all the nulls to 0 to match your desired output

 

mst3k_0-1634189134740.png

 

Peachyco
8 - Asteroid

@mst3k's solution works. If you'd like to clean up the column names, you can add a "Dynamic Rename" tool in the end. You can use the REGEX_Replace function to replace the underscores (_) with spaces. 😊

Labels