Hello,
I have two data sets:
How do I join both lists together without having my data duplicated? I have used split to column to show Exam Help with column so this shows one subject her field. When I do a join my data join for ever possible match, when I just want to match one and move to the next subject.
Data below
Thanks
Solved! Go to Solution.
@Sam7 Can you provide the expected result as well please?
Good Point.
I am open here, but somethinglike:
Matt there is no-one to help with Art, with Maths he can join to the first one on senior list Harry,
Gemma can join on English with Jake
So everyone joins once to a senior based on their subject. They I can pair them off to work together. I do not know how to correctly pair a student with a senior based on their requirement. I only want a 1-2-1 relationship. I hope I have explained myself well.
I am using VERSION 2021.2.1.35394 therefore I can;t open this. What is the plain round circle doing?
Many thanks.
Please assist, I am having trouble downloading the data as I am using an older version of Alteryx, is there anyone I can download this? I really wanted to implement this.
@binuacs Thank you for your kindness and follow-up. 😁
That took some work to understand that. I am very new to Alteryx. Thank you kindly for your help