Incremental Load, Maybe?

[samuel_brierley]

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);

[Gysbert_Wassenaar]

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?

[samuel_brierley]

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.

[Gysbert_Wassenaar]

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

[samuel_brierley · Accepted solution]

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

[samuel_brierley]

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

[Gysbert_Wassenaar]

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?