Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Valued Contributor

Re: loading data

hi,

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

LET variable1 = NoOfRows('tab1');

Thanks

6 Replies
Not applicable

Re: loading data

load

..

..

..

from test.qvd(qvd)

where Date < today();

vivientexier
Contributor II

Re: loading data

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

Re: loading data

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

Re: loading data

hi all

any updates

Not applicable

Re: loading data

hi all

any luck

amars
Valued Contributor

Re: loading data

hi,

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

LET variable1 = NoOfRows('tab1');

Thanks

Community Browser