How to Join two tables with out having unique values?

[d_koti24]

Hi All,

How to Join two tables with out having unique values?

[alexandros17]

Could you explain with more details please?

[sunny_talwar]

May be use Mapping Load instead of join. Will need to get more details, like looking at your current script before giving a more precise answer.

Best,

Sunny

[jagan]

Hi,

If you attach sample data and your expected output then it will be easier to provide the solution.  There may be many solutions like Mapping Load or Keep.

You can try those.

Regards,

jagan.

[kuczynska]

Did you try to build your own key - concatenated key in each table?

looking like the below example

system_of_customer_id & '~' & source_customer_id as %KEY_Customer

but as the guys before me mentioned, you have to provide more details. You should consider both join and ApplyMap, depending on how many columns you want to bring across.