Discussion Board for collaboration on QlikView Scripting.
i have two tables one is Time_dim and other is manufacturing....
Time_dim has fields:
Manufacturing table has fields:
i want to apply the filter on time_id to load only previous day data from manufacturing table and schedule it for every day....
my problem is..how to store the time_id from time_dim table to a variable so that i can aply filter condition to measurement table
You can try in this way.
Resident Data where time_date = Pre. date
Drop table Data;
Here Pre. Date is a calculation for pre.date.
Problem with joining table with manufacturing is... it is having billions of records
Is there any other way..?
If you've applied the filter in the time_dim table, you can use the Exists() function to apply in manufacturing table.
In manufacturing, it will only load rows which time_id has been previously loaded in the time_dim table.
Hope it helps.