Create several matrix within one workflow

Question

Hi all!

I want to create a transaction matrix within Alteryx.

The matrix should be created on the basis of a list containing the following columns (see screenshot attached):

* Sender
* EUR Sender
* Receiver
* EUR Receiver
* Service
* Country

In the column Sender are several Company Codes.

For each of those a matrix should be created. The structure of the matrix will look as on the attached screenshot.

I already have the steps defined in order to create a transaction matrix, the values of EUR Sender will be summarized (see screenshot of workflow attached).

Since the Sender Column contains several different company codes I want to find a dynamic, automated solution to create a matrix for each company code instead of applying a filter on the company code (maybe using a macro is a solution?).

Does anyone have an idea on how I can do that? I want the different matrix be written into the same Excel file but all in a separate sheet.

I appreciate any help that you can offer!

Many thanks in advance and kind regards

Kim

image.png

OTrieger · Answer

@kim09 
Summarise tool will do just that, as you can group the data based on different variables.

jrlindem · Answer

@kim09 were you able to solve this problem?  Otherwise, as @Raj requested, please attached sample data in the original format as well as what/how you expect it to output.  From there, we can mockup a solution.  -Jay

Raj · Answer

@kim09, please add sample input file.