topic Load data based on QVD data in QlikView

Load data based on QVD data

Wed, 21 Mar 2012 21:11:59 GMT

Hello

I need to load data from SQL ODBC based on Date already loaded into a QVD.

The process would be like:

1) Check MAX(DateColumn) inside QVD

2) Load data from SQL ODBC where DateColumn in SQL table > MAX(DateColumn) in QVD

is this possible?

how would the script look like?

Thanks!

Load data based on QVD data

Wed, 21 Mar 2012 21:38:38 GMT

temp:

Load Date

from qvd;

res:

Load max(date) as MaxDate

resident temp;

let vMax=peek('MaxDate',-1,'temp');

Current:

select * from Sql table

where Date > vMax;

concatenate

load * from qvd;

Re: Load data based on QVD data

Wed, 21 Mar 2012 23:02:05 GMT

Hi armando,

It sounds like you want to do something similar to an incremental load. If you would like all transactions where the date does not exist in your QVD though (and avoid duplicate loads based on your date column - as it seems you are), what could possibly be of use is a where not exists statement.

First Load your QVD table with DateColumn as qvdDate. Then in your SQL Load, include:

Where Not Exists (DateColumn, qvdDate)

Hope this helps,
Ian.

Load data based on QVD data

rwunderlich — Thu, 22 Mar 2012 02:39:01 GMT

For more on incremental load, see http://qlikviewnotes.blogspot.com/2012/01/incremental-load-using-qlikview.html

-Rob