topic Re: Drop Table in QlikView

Drop Table

tyagishaila — Tue, 16 Dec 2014 06:42:14 GMT

Hi Community Members,

Is it always necessary drop< table>, if we are using resident table?

Re: Drop Table

Anonymous — Tue, 16 Dec 2014 10:28:24 GMT

Hi Shaila

It is not necessary to drop table if you are using Resident

we drop it because to avoid synthetic keys

if the scrip looks like below you does'nt need to drop the table as they are not linked

Table1:

load

Name,

Marks

from

test.xlsx(.........)

Sum_table:

Load

Name as New_Name,

sum(Marks) as New_Marks

resident Table1;

if the script look like below the you need to drop because they form the synthetic key

Table1:

load

Name,

Marks

from

test.xlsx(.........)

Sum_table:

Load

Name

sum(Marks) as Marks

resident Table1;

Regards

Harsha

Re: Drop Table

tyagishaila — Tue, 16 Dec 2014 10:32:09 GMT

Okay,

Thanks Harsha

Re: Drop Table

saumyashah90 — Tue, 16 Dec 2014 10:36:09 GMT

Hi Shaila,

It is not necessary but if we don't drop it will creat a duplicate table or else it will concatenate .

Re: Drop Table

tyagishaila — Tue, 16 Dec 2014 10:47:41 GMT

And if we join two tables then is it necessary, to drop any of table.

(we are not using resident table here, because both tables are different)

Re: Drop Table

Anonymous — Tue, 16 Dec 2014 10:49:46 GMT

Close the post my mark it as correct answer if you got the correct answer so it can be helpful to others

Regards

Harsha

Re: Drop Table

Tue, 16 Dec 2014 11:00:03 GMT

Hi Shaila,

If you join two tables, why do yu need to drop any of them?

Re: Drop Table

saumyashah90 — Tue, 16 Dec 2014 11:06:22 GMT

1)Once you Join the Table it will generate one table having the resultant data ....so no extra table will be left to drop..

2)But if you use keep you might have to drop it in future

Re: Drop Table

tyagishaila — Tue, 16 Dec 2014 11:08:19 GMT

Hi Pooja,

Actually I don't need, I am just asking.

because when we join tables then both table join into one table.

after that if we drop 2nd table. then can we lost information?

Re: Drop Table

Tue, 19 May 2015 12:03:45 GMT

Hi,

As per my understanding, Drop table can be added in the start of the script to remove synthetic tables.

Drop table [$Syn Table 1];

....................................

Set date...

Set time...

..................................

Regards,

Kuldeep

Re: Drop Table

Tue, 19 May 2015 12:12:10 GMT

SUB WildcardDropTables (vExpression) // Loop through the tables within the model FOR i = 0 TO noOfTables()-1 STEP 1 // Get the current table name LET vCurrTable = tablename(i); // Get the current table name // If the table name matches the pattern then drop it IF wildmatch('$(vCurrTable)','$(vExpression)') THEN DROP Table [$(vCurrTable)]; LET i = i - 1; // Needed as table index reduces once table is dropped END IF NEXT // Clear the variables so they don't persist LET vExpression = null(); LET vCurrTable = null(); END SUB