Joining 2 data sets

[MKanchwa]

Hi All,

I have 2 data sets as shown below

I want the output as

Could anyone please help me on this?

Thanks

Mustafa

[mceleavey]

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.

[pedrodrfaria]

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.

[MKanchwa]

Hi  mceleavey,

This would duplicate the entries in the Annual score column.

Thanks

[pedrodrfaria]

Hi @MKanchwa 

I believe my post above does what you are looking for. Please let me know if I am missing anything.

Pedro.

[mceleavey]

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.