Loading table from ODBC database without SQL statements

Anonymous — Mon, 19 Nov 2018 12:26:34 GMT

Hello dear Community!

I would like to load a table from an ODBC database, but filter the colums before i load them, because the entries are huge and my loadscript takes lots of time to load it. As I can see, the wizard uses SQL statements, for instance:

random_table:
SQL SELECT column1,
column2,
column3
FROM owner."table_name";

As far as I know, I can't use functions like "for" or "if" with SQL statements.

So my question is: Can I load tables from databases without SQL statements (like regular Excel or CSV files)?

My Goal is to do something like this:

*loading table1 with column1*

new_table:
for column1 in table1:
       load
         .
         .
         .
from table2 where column2=column1;

table2 is the huge one, I would like to filter before loading it...

Thank you very much in advance!

Re: Loading table from ODBC database without SQL statements

tomasz_tru — Mon, 19 Nov 2018 13:50:13 GMT

Can't you just use WHERE in the SQL statement?

Tomasz

Re: Loading table from ODBC database without SQL statements

Anonymous — Tue, 20 Nov 2018 07:30:02 GMT

Thanks for your reply,

unfortunately not...

topic Re: Loading table from ODBC database without SQL statements in QlikView

Loading table from ODBC database without SQL statements

Re: Loading table from ODBC database without SQL statements

Re: Loading table from ODBC database without SQL statements