Droping tables in the script

[#1]

Hi,

I created 4 qvd's and pulled into another qvw file, but not sure where to drop the tables in the script.

ALL:

LOAD * from IMF.qvd(qvd);

JOIN LOAD * from WIF.qvd(qvd);

JOIN LOAD * from DIL.qvd(qvd);

JOIN LOAD * from DIH.qvd(qvd);

//DROP TABLE IMF;

//DROP TABLE WIF;

//DROP TABLE DIL;

//DROP TABLE DIH;

FINAL:

LOAD * RESIDENT ALL;

//DROP TABLE ALL;

I see ALL after executing the script, but I suppose to see FINAL table in the table viewer. And where to drop the tables?

Thanks,

[#2]

Yep Anand, the syntax working fine without no concatenate.

Thanks,

[ankit777]

Hi ,

You can use this.

ALL:

LOAD * from IMF.qvd(qvd);

JOIN LOAD * from WIF.qvd(qvd);

JOIN LOAD * from DIL.qvd(qvd);

JOIN LOAD * from DIH.qvd(qvd);

DROP TABLES IMF,WIF,DIL,DIH;

NOCONCATENATE
FINAL:

LOAD * RESIDENT ALL;

DROP TABLE ALL;

[#4]

ALL:

LOAD * from IMF.qvd(qvd);

JOIN LOAD * from WIF.qvd(qvd);

JOIN LOAD * from DIL.qvd(qvd);

JOIN LOAD * from DIH.qvd(qvd);

The above script making join among the tables, because I am getting double the records, not sure whether it is doing join or not?

Thanks,

[#5]

Use NoConcatenate in front of LOAD which is being used for FINAL table as shown below.

ALL:

LOAD * from IMF.qvd(qvd);

JOIN LOAD * from WIF.qvd(qvd);

JOIN LOAD * from DIL.qvd(qvd);

JOIN LOAD * from DIH.qvd(qvd);

//DROP TABLE IMF;

//DROP TABLE WIF;

//DROP TABLE DIL;

//DROP TABLE DIH;

FINAL:

NoConcatenate LOAD * RESIDENT ALL;

DROP TABLE ALL;

REM : Reason behind having only ALL table is, when you are using Load * on FINAL table, the FINAL table is getting concatenated with ALL table, becuase qlikview automatically concatenates the 2nd load table, if it sees that 2nd table has all the fields with same name;

[#6]

I am dropping the ALL table before final load right, so still do we need No concatenate?

Thanks,