Discussion board where members can learn more about Qlik Sense Data Connectivity.
Something like in a Load Script
xtable:LOAD *,newfieldFROM [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_10but it´s not necessary , it´s create a circular refenrence
How to remove this table from Model ?
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
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) Thendrop table [$(tt)];EndIf;next;