loading data

[#1]

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

[#2]

load

..

..

..

from test.qvd(qvd)

where Date < today();

[vivientexier]

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.

[#4]

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

[#5]

hi all

any updates

[#6]

hi all

any luck

[amars · Accepted solution]

hi,

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

LET variable1 = NoOfRows('tab1');

Thanks