topic Re: Unnecessary table in final Model in Connectivity & Data Prep

Unnecessary table in final Model

Pdmotta — Mon, 13 Dec 2021 17:33:19 GMT

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

Re: Unnecessary table in final Model

andoryuu — Wed, 04 Dec 2019 20:24:20 GMT

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!

Re: Unnecessary table in final Model

Pdmotta — Fri, 06 Dec 2019 19:32:42 GMT

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;