Multiple Row field

Question

Hello Everyone,

I am trying to learn Alteryx and have one question related to the Multiple row field.

There is a situation where I need to find out if S1:S2 is 1:1 mapping or N:1 mapping. Can you please help me as to how I can obtain the result.

Please find screenshot

cplewis90 · Accepted Answer

Hey @Ragini1,

Welcome and you chose a good tool to learn! One thing that helped me as a sidebar is the Academy section of the community! So much great content there!

I took a different approach than the multi row. I leveraged a summarize tool to identify how many S1's are associated to S2 and then created a field using a formula tool to identify a 1:1 or N:1 mapping.

DavidP · Accepted Answer

Hi @Ragini1

I wouldn't use the multi-row formula for this purpose. Yes, you can compare values for multiple rows, but you have to 'hard-code' the tests and do it row by row.

For your purpose, I would use the Summarize tool, making use of the Group by option in this tool.

The idea is to create groups of the unique values of S2 and then within each group, you can count the number of unique S1 values or display them all.

Here's an example and workflow attached.