Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

drop table from data model via script

Hi community,

i have loaded a lot of tables into my app.

now i want a table to be deleted.

so i used Drop Table tablename;

the table is not existing in the script and the drop table runs into table not found but its still

in the datamodel and in the datamanager even after restart of the app.

Please help me thx in advance

1 Solution

Accepted Solutions
amayuresh
Creator III
Creator III

table1:

Load Col1,Col2, Col3 from x;

table2:

Load Col1,Col2, Col3 from x;


both table get merge into table1. So need to drop table1.

I think this will clear your doubt.

View solution in original post

17 Replies
Gysbert_Wassenaar

Are you sure you didn't misspell the name of the table?

Can you post a .qvf that demonstrates this behaviour?


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert

here a screenshot of the data model

NosBos.PNG

here the statement

Drop Tables NosBos ;

and the datamanager

nosbos_1.PNG

Gysbert_Wassenaar

And you're sure your drop statement is after any statement that creates, joins or concatenates anything to that table?


talk is cheap, supply exceeds demand
martinpohl
Partner - Master
Partner - Master

you wrote

the table is not existing in the script and the drop table runs into table not found but its still

in the datamodel and in the datamanager even after restart of the app.

So where is the table be generated at?

Regards

swuehl
MVP
MVP

Are you sure the screenshots represent the same data model at the same state / point in time?

Just because your data model shows a lot of fields and data manager tells 3.

Not applicable
Author

Hi

i did all at the same time in the same app.

after restart it stays the same.

i deleted it in the script but its seems like the delete was not completed correctly.

and the table was generated in the script.

NareshGuntur
Partner - Specialist
Partner - Specialist

Try moving your drop statement to the end of the script.

I think the table is getting created after the drop statement.

Cheers,

Naresh

Not applicable
Author

i thought the same why but u and I where wrong.

Even at the end of  the script he doesnt found the table.

amayuresh
Creator III
Creator III

Please check below conditions in your script,

1. You are not joining all tables in single table, then need to drop firstly loaded table name

2. You are loading all table having same fields, then need to drop firstly loaded table name

3. Use table name, which loaded separatly & showing separate table in data model