I have 3 files with Unique key, would want to join 3 without creating duplicates

[nidah5]

i have 3 files with 2 different column names in each file and 1 unique identifier.

when i am trying to join it, its creating duplicates of ID, i want 1 single row for each ID with all the variables from all 3 files in same row, without data loss.

i have attached the workflow.

[JosephSerpis · Accepted solution]

Hi @nidah5 I mocked up a workflow which I think produces the output you want. Let me know what you think? If this is not correct can you please share an output you want to achieve?