Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Need help with a join for a resident table


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;

3 Replies
Not applicable

Re: Need help with a join for a resident table

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;

Not applicable

Re: Need help with a join for a resident table

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

Not applicable

Re: Need help with a join for a resident table

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

Qualify *;

Unqualify REPORT_MONTH, CURRENCY ;