Loading Data

Thu, 08 Oct 2009 23:48:48 GMT

I need some help in trying to determine the best way to load new data. There will be an initial load of all data and then each day new files are created and dumped to an FTP server. The files contain the data from the previous day. The file naming convention is as follows:

website_history2009-10-01_200933.csv

website_history2009-10-02_200933.csv

website_history2009-10-03_200933.csv

etc.

Any suggestions on how I could load the additional data from the new files each day?

Loading Data

Fri, 09 Oct 2009 03:02:47 GMT

You can upload two ways:

1 -. Upload all:
website_history *. csv

2 .- Load per day:

Let Today= 'Date(Today(),'YYYY-MM-DD')';
website_history $ (Today) _200933.csv

You can do a QVD, storing the days already loaded and then joining them at the present day.

topic Loading Data in QlikView

Loading Data

Loading Data