Multiple Row field

[Ragini1]

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 solution]

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 solution]

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.

[jarrod]

Hi @Ragini1 ,

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

There are several ways to accomplish this and seeing that there wasn't a defined required output stated, i'll go ahead and mark both responses as solutions.

As the original author, you also have the ability to mark replies as solutions! Going forward, I’d encourage you to identify the solution or solutions that helped you solve your problem, as it's a big help to other community members. Learn more about Accepted Solutions here.

Thank you!