Help Creating a Matrix

[seth_fuller]

Hello all!

I've run into an issue where I am trying to create a matrix to show the number of identifiers that end up in multiple different values in the same column. I have attached a workflow as an example of what I am trying to achieve.

Essentially its a count of IDs that have a record of value A and Value B

Let me know if you have any questions. Appreciate the help!

Seth

[braveraj]

I don't know if it necessarily solves your matrix problem but I've attached a solution. Double check it looks right to you.

 

[seth_fuller]

Appreciate the help. Thats not quite doing what I'm looking for.

I want to know of the potential combinations of Items (in this case Pizza, Burgers, Chicken Tenders, Fries) how many IDs crossed these. The output in the attached workflow is accurate to the numbers I'm trying to replicate.

So you'll see in the below, that there is 1 instance where an ID had Pizza multiple times

Input:

Output:

[seth_fuller]

Hoping to push this back up to the top of the forum in hopes to get an answer

[RSreeSurya]

Hi,

If you can help with exact output (Format & Numbers) you are looking for, for my better understanding. 

Will create a workflow accordingly. 

Thanks