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!
