Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
All identical field names will be used as join keys. In your example, it looks like both fields will be used as join keys.
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