how to join two tables by avoiding Duplicate

[#1]

hi all,

i have two tables i want combine that two tables

with out any duplication in records

i have attached the two sample files

plz help

[#2]

Hi,

you can join these 2 tables on currency code

LOAD CurrencyCode as %C, *  from table 1

join

LOAD CurrencyCode as %C, *  from table 2

If you need to join on currency+date you must take only date format without minutes

best regards

chris

[#3]

i tried that one but it is creating duplicates

yes we can ignore Modified date from any one

but i want Currency name from table 2 to table 1

[salto]

Then you need to change the join order:

LOAD CurrencyCode as %C, *  from table 2

join

LOAD CurrencyCode as %C, *  from table 1

HTH.

[#5]

i didn't get u

would u please try this on my data set and provide me a QVW

[#6]

Except EURO and US i can't see no dupplicates.

If you want only 1 line for EURO and US you must add where not exists

best regards

Chris

[salto]

Hi,

I did a left join from S1 to S2. This means that it will hold  records from S1 that have a corresponding CurrencyCode on S2 are in the final table.

If you want all records, just delete the left and leave it as a natural join. Or if you only want the currencies in S2, replace the left for right.

Hope this helps.

[kaushalview]

Hi,

if u dont want the duplicate records in your application then use Left keep between two table for joining.

Regards

Kaushal Mehta