topic Re: how to join two tables by avoiding Duplicate in QlikView

how to join two tables by avoiding Duplicate

Thu, 31 Oct 2013 12:23:30 GMT

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

Re: how to join two tables by avoiding Duplicate

Thu, 31 Oct 2013 12:28:07 GMT

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

Re: how to join two tables by avoiding Duplicate

Thu, 31 Oct 2013 12:35:43 GMT

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

Re: how to join two tables by avoiding Duplicate

salto — Thu, 31 Oct 2013 12:39:40 GMT

Then you need to change the join order:

LOAD CurrencyCode as %C, * from table 2

join

LOAD CurrencyCode as %C, * from table 1

HTH.

Re: how to join two tables by avoiding Duplicate

Thu, 31 Oct 2013 12:42:10 GMT

i didn't get u

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

Re: Re: how to join two tables by avoiding Duplicate

Thu, 31 Oct 2013 12:46:30 GMT

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

Re: Re: how to join two tables by avoiding Duplicate

salto — Thu, 31 Oct 2013 12:55:17 GMT

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.

Re: how to join two tables by avoiding Duplicate

kaushalview — Thu, 31 Oct 2013 13:07:16 GMT

Hi,

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

Regards

Kaushal Mehta