topic Question regarding key in left join in QlikView

Question regarding key in left join

Mon, 31 May 2010 21:12:41 GMT

Hello all!

I think this is an easy question for you. What key is used in this left join? Both CurrencyCode and %CurrPeriod? or one of them?

Br,

Cristian



tmpTable:
LOAD Product, Date, %CurrPeriod,CurrencyCode, InvoicedValue
FROM qvd\ODS.qvd (qvd);
PrimeConv:
LOAD CurrencyCode, %CurrPeriod,round(AverageRate, 0.0001) as Rate
FROM qvd\Currency.qvd (qvd);
LEFT JOIN (tmpTable)
LOAD * RESIDENT PrimeConv;
DROP TABLE PrimeConv;

Question regarding key in left join

Oleg_Troyansky — Mon, 31 May 2010 21:30:23 GMT

All identical field names will be used as join keys. In your example, it looks like both fields will be used as join keys.

Question regarding key in left join

Tue, 01 Jun 2010 06:37:56 GMT

In Left Join , it will work like full outer join and match the indentical keys fro join......

As Oleg told i think both the field will work