Data required in same first Row.

[Rhaldhar]

Hi All,

Can you please help me to get the Infront of same data? I have input 1 and input 2 and using join multiple tool to get the result but not working.

Input 1 & input 2

getting result.

However, I need below result/output. 

Thanks,

Rajeev

[gawa]

@Rhaldhar 

I guess you select option "Join by Record Position". To meet your demand, it should be "Join by Specific Fields", and select "unique_id" for key fields.

[Rhaldhar]

Hi @gawa , I have used join by specific field but creating two line highlighted in circled, that i don't want.

Thanks

[ed_hayter · Accepted solution]

This is odd because you have a "Unique ID" that is repeated so not unique.

If you are happy with this and want to proceed to your output the following workflow should work:

We use a multi row grouped on unique ID to label the repetition of the unique ID we are on. I.e. the first 323 should join to the first 323 but not the latter.

We then join on unique ID and REP ID union on the unjoined case to get the desired output

[Rhaldhar]

Hi @ed_hayter thanks for the solution.