Discussion Board for collaboration related to QlikView App Development.
I have multiple table in a database:
I need to load all of them in a single table.
I am trying the below but it does not seem to work:
SQL SELECT *
I have generated Table Name from Jan 2015 to Current month
LOAD 'TEST_' & date(Monthstart(Date),'YYYY_MM') as Name;
LOAD makedate(2015,1,1)+iterno()-1 as Date
While makedate(2015,1,1)+iterno()-1 <= today();
LOAD * inline [
for i=1 to fieldvaluecount('Name')
let vName = fieldvalue('Name',$(i));
'$(vName)' as TableName;
drop field Junk;
Store Final into ..\Final.QVD;
View solution in original post
You can use the SQLTABLES SQL function to retrieve a list of your tables in your DB. Then iterate over the tables names using FOR ... NEXT
Have a look at your DBMS manual, there are also examples here in the forum how to do this in QV script.
LOAD * ;
I used to do that but the problem is that every month a new table is created in the database.
We have already reached like table TEST_2016_04
I need a dynamic way to do it.