topic Re: Incremental Load, Maybe? in QlikView

Incremental Load, Maybe?

samuel_brierley — Tue, 10 Mar 2015 09:06:47 GMT

Hi all,

pretty sure this is a common question but ive looked for answers, although im sure their there i dont understand them :S

first of all im doing a normal load of data from an excel file e.g Run 0

next week i will use the exact same load script but change the path to Run 1 i.e 2 different files

when i click reload both Run 0 and Run 1 will be loaded.

whats the easiest way to tell qlikview not to bother with Run 0?

thanks for any help

LOAD

Location_ID,
      Location,
      Lane,
     (ULO_Count - Peek(ULO_Count,-48)) as [Non-Cumulative],
      (ULO_Count_VT1 - Peek(ULO_Count_VT1,-48)) as [Non-Cumulative_VT1],
    (ULO_Count_VT2 - Peek(ULO_Count_VT2,-48)) as [Non-Cumulative_VT2],
    (ULO_Count_VT3 - Peek(ULO_Count_VT3,-48)) as [Non-Cumulative_VT3],
     Time(SLO_Sim_Time,'hh:mm:ss') as [Smoothed Time],
     time( maketime( hour( Time(ULO_Sim_Time)) , minute(Time(ULO_Sim_Time))) , 'hh:mm' ) as Minute,
   time( maketime( hour( Time(ULO_Sim_Time))) , 'hh:mm' ) as Hour,
   Time(Floor(Time#(Left([ULO_Sim_Time],4),'hh:mm'),1/24/4),'hh:mm') as [15 Minute],
   Run
FROM

(ooxml, embedded labels, table is Loop);

Re: Incremental Load, Maybe?

Gysbert_Wassenaar — Tue, 10 Mar 2015 09:53:36 GMT

I don't understand your problem. Are you saying that when you change the load statement to load from a different excel file that Qlikview still also loads from the file specified before you changed the script?

Re: Incremental Load, Maybe?

samuel_brierley — Tue, 10 Mar 2015 09:57:07 GMT

No, I am running a test model which outputs a spreadsheet. the spreadsheet(s) are then loaded into qlikview. when i run a new test i want to be able to load the new spreadsheet into Qlikview without loading those that are already in.

Re: Incremental Load, Maybe?

Gysbert_Wassenaar — Tue, 10 Mar 2015 10:00:07 GMT

And you can't simply use one source location and move the files elsewhere after loading the data into Qlikview?

Re: Incremental Load, Maybe?

samuel_brierley — Tue, 10 Mar 2015 10:02:45 GMT

I could yes but when i click reload the Qlikview will be unable to find the files I have moved, unless im missing something.

Re: Incremental Load, Maybe?

samuel_brierley — Tue, 10 Mar 2015 10:05:03 GMT

I think Ive sussed it, what im after is partial reload and ADD not incremental, thanks for replying

Re: Incremental Load, Maybe?

Gysbert_Wassenaar — Tue, 10 Mar 2015 10:06:21 GMT

Then don't move them and use a wildcard to load them all.

LOAD * FROM (ooxml, embedded labels, table is [Sheet1]);

Or am I misunderstanding you again?