topic Re: loading data in QlikView

loading data

Wed, 01 May 2013 10:44:21 GMT

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

Re: loading data

Wed, 01 May 2013 11:01:13 GMT

load

from test.qvd(qvd)

where Date < today();

Re: loading data

vivientexier — Wed, 01 May 2013 11:04:18 GMT

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.

Re: loading data

Wed, 01 May 2013 11:46:45 GMT

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

Re: loading data

Wed, 01 May 2013 13:32:26 GMT

hi all

any updates

Re: loading data

Wed, 01 May 2013 14:43:29 GMT

hi all

any luck

Re: loading data

amars — Wed, 01 May 2013 14:54:22 GMT

hi,

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

LET variable1 = NoOfRows('tab1');

Thanks