Hi All,
I have 2 data sets as shown below
I want the output as
Could anyone please help me on this?
Thanks
Mustafa
Hi @MKanchwa ,
this is a simple join using the Join tool.
You select the key field on which you want to join, then drop the key field from the second input (as they are the same).
I've attached the workflow for you.
Hope this helps.
M.
Hi @MKanchwa
Please see attached for the workflow.
We need to join first and then use the multirow to eliminate the duplicate information on the Annual Score column.
You could also use the unique to separate them, remove the annual score column and the union to put it together again. Different ways to approach this.
Pedro.
Hi @MKanchwa
I believe my post above does what you are looking for. Please let me know if I am missing anything.
Pedro.
Hi @MKanchwa ,
this is just a case of removing them if they are the same grouped by Name and ID.
@pedrodrfaria 's response handles this but I've attached my multi row here as well.
M.