Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to load for example two tables and I'd like to use some of the previously defined fields to filter the second table. How could I do this? I'd like to use both of the tables after the loading, so the first table is not a temptable. Because I get an error message which says, that 'The Filed does not exist'.
For example.:
Table1:
Load t1_ID,
t1_date;
FROM datasource;
And now I'd like to filter the Table to like that.: t2_ID = t1_ID and t2_date < t1_date. Neither Preload function nor SQL is working.