Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Pdmotta
Contributor II
Contributor II

Unnecessary table in final Model

Something like in a Load Script

 

xtable:
LOAD *,
newfield
FROM [extract_*.qvd](qvd);

//this * is an year and month

Store * from xtable into [...xtable.qvd] (qvd);

In the final Model remains a table extract_2019_10
but it´s not necessary , it´s create a circular refenrence

How to remove this table from Model ?

Thanks

Labels (1)
1 Solution

Accepted Solutions
andoryuu
Creator III
Creator III

At the end of your data load script write:

drop table extract_2019_10;

 

You can also use For Each statements to do this programatically if you're stuck changing the name of the file in your data load.

 

If this answers your question please mark it as the solution.  Thanks!

View solution in original post

2 Replies
andoryuu
Creator III
Creator III

At the end of your data load script write:

drop table extract_2019_10;

 

You can also use For Each statements to do this programatically if you're stuck changing the name of the file in your data load.

 

If this answers your question please mark it as the solution.  Thanks!

View solution in original post

Pdmotta
Contributor II
Contributor II
Author

Thanks , it´s works but I need to drop from a list , all table that have a "XYZ" in hi name  , I´ve used that

 

let numTables = NoOfTables();
for i=1 to $(numTables)
let tt = TableName(i);
if (SubStringCount('$(tt)','XYZ') > 0) Then
drop table [$(tt)];
EndIf;
next;