Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

loading data

HI All,

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

thanks

1 Solution

Accepted Solutions
amars
Specialist
Specialist

hi,

to get the Total No of Rows in your script you can use a scriptline like this

LET variable1 = NoOfRows('tab1');

Thanks

View solution in original post

6 Replies
Not applicable
Author

load

..

..

..

from test.qvd(qvd)

where Date < today();

vivientexier
Partner - Creator II
Partner - Creator II

The Exists() function will help you.

Test:

Load

    Date

  , B

  , C

From

    Test.qvd (qvd)

Where

    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.

Not applicable
Author

thanks all. but i believe you have not understood the question. let me try again

assume i do the below:

load

.

.

.

. 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

load

.

.

.

. from excel file for today's data

please help

thanks

Not applicable
Author

hi all

any updates

Not applicable
Author

hi all

any luck

amars
Specialist
Specialist

hi,

to get the Total No of Rows in your script you can use a scriptline like this

LET variable1 = NoOfRows('tab1');

Thanks