Alteryx Designer Discussions

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

Cross Matrix

Tommy23
7 - Meteor

Hello

I have receives this transaction for each customer and cities.

I want to create a matrix which displays the total number of nights spend in each city in relation to the other cities also purchase by that customer.

I send you the Input data and the output data. I try to use cross tab and also MB_Affinity but without success. Can you please help me.

 

Thanks in advance for your answer, best regards!

 

 

6 REPLIES 6
suby
11 - Bolide

Hi Tommy,

 

Please find the attached to WF.

 

Thanks.

NexBK
7 - Meteor

Hi, @Tommy23 

 

I solved this question with Macro.

Connect the City list to this macro and set it up.

NexBK_0-1659917935942.png


I hope you get the result you want.
I attach the yxzp file (package file).

 

Qiu
19 - Altair
19 - Altair

@Tommy23 
I managed to do it by a Macro.

0808-Tommy23.PNG

Qiu
19 - Altair
19 - Altair

@NexBK 
I think we are the similar approach 😁

Tommy23
7 - Meteor

Hello, @NexBK @Qiu 

 

I can not open the macros, an error happen "" The entry point is invalid"

Usually this happens when workflow is not completely packaged. Macros should be selected (highlighted are macro which needs to be checked) while saving it as packaged workflow.

 

Can you please upload a new file thanks in advance

Qiu
19 - Altair
19 - Altair

@Tommy23 
I downloaded my workflow package and it works just fine.
let me upload them again.

0808-Tommy23-1.PNG

Labels