topic Re: Cross Matrix in Alteryx Designer Desktop Discussions

Cross Matrix

Tommy23 — Sun, 07 Aug 2022 16:16:41 GMT

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!

Re: Cross Matrix

suby — Sun, 07 Aug 2022 23:25:44 GMT

Hi Tommy,

Please find the attached to WF.

Thanks.

Re: Cross Matrix

NexBK — Mon, 08 Aug 2022 00:20:54 GMT

Hi, @Tommy23

I solved this question with Macro.

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

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

Re: Cross Matrix

Qiu — Mon, 08 Aug 2022 00:26:31 GMT

@Tommy23
I managed to do it by a Macro.

Re: Cross Matrix

Qiu — Mon, 08 Aug 2022 00:27:30 GMT

@NexBK
I think we are the similar approach 😁

Re: Cross Matrix

Tommy23 — Mon, 08 Aug 2022 09:13:40 GMT

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

Re: Cross Matrix

Qiu — Mon, 08 Aug 2022 22:41:21 GMT

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