load of a variable numbers of databases

[FrankGrimm]

Hello together,

i have a variable numbers of CSV tables with different names but the same table structure.

The names of the existing CSV tables are listet in a special table. 

This content of this list is changing. 

Special list Example 1

Special list Example 2  (maybe 2 hour later)

With every load order, i have to load all the CSV tables which are existing in this moment and listed in the special CSV table.

How i´m able to build a variable load script?

Thanks a lot!

Frank

[Aurelien_Martinez]

Hi,

//load csv file with tables names

Load

  tableName

From tables.csv

;

//iterate on table name and load each table

for each vtable in fieldvaluelist('tableName')

SQL select * from $(vtable);

next vtable

[FrankGrimm]

Hello,

thanks a lot.

Perfekt It works!

It's simple if you know how 😉

Frank