topic Need help with a join for a resident table in QlikView

Need help with a join for a resident table

Wed, 13 Aug 2014 17:10:30 GMT

Cant wrap my head around this... I would like to create a temp table called Incremental, using columns from Balance, and a single column from Rate (ask). Can anyone point out how I should do this? I want to use Incremental to fill in a straight table...

Balance:
SQL SELECT REPORT_MONTH,
ID,
CURRENCY
FROM mydb.dbo."BALANCE";

Rate:
SQL SELECT REPORT_MONTH,
CURRENCY,
ASK
FROM mydb.dbo."RATES";

Incremental:
LEFT JOIN (Rate)
LOAD Balance._ID,
Balance.CURRENCY,
Rate.ASK
RESIDENT Balance;

Re: Need help with a join for a resident table

Wed, 13 Aug 2014 17:18:23 GMT

Why not:

Incremental:

Noconcatenate

Load * Resident Balance;

Left Join

Load * Resident Rate;

Drop Tables Balance,Rate;

The two tables will be joined based on REPORT_MONTH and CURRENCY field;

Re: Need help with a join for a resident table

Wed, 13 Aug 2014 18:12:16 GMT

If i am qualifying, do i need to add the source table names before the column names?

Re: Need help with a join for a resident table

Wed, 13 Aug 2014 18:47:37 GMT

In that case you can just unqualify the two fields that are used for joining. It will be

Qualify *;

Unqualify REPORT_MONTH, CURRENCY ;