Discussion Board for collaboration on QlikView Scripting.
i have test.qvd(qvd) and daily i append new data in this qvd
i need to put a control in script if today's data is present in test.qvd(qvd) then do not append. this i will be able to check based on Date column in test.qvd(qvd)
so could you please share the correct syntax
Go to Solution.
to get the Total No of Rows in your script you can use a scriptline like this
LET variable1 = NoOfRows('tab1');
where Date < today();
The Exists() function will help you.
Not Exists (Date);
This will load only rows where the value inside 'Date' has not been already load in the script.
Load 'Date' before in another table (like this 'Date' will exists), then do like the example above.
thanks all. but i believe you have not understood the question. let me try again
assume i do the below:
. from test.qvd(qvd) where Date = Today()
now suppose today's data is not loaded in the past - output will be zero rows
i need to capture count of rows from this result and then put that value in a variable to use it in a if statement liek below:
if variable =0 then
. from excel file for today's data