pick data using generic load

Wed, 15 Apr 2015 11:07:32 GMT

Hello,

I have a script in which a Table from a database ([TimeStamp],[DataName],[Value]) is loaded using the generic load. The Table is large and causes a long loading time. On top of that in a certain script it also causes a crash. I would like to pick several entries and not load those, I don't need. This is a part of the script:

LOAD Floor(Timestamp) as %Datum,
          Dataname,
          Sum(Value) as Value

Group By Timestamp, Dataname
;
SQL SELECT
    Timestamp,
     Dataname,
     Value
     FROM MySource;

A calander follows which I left out for better clarity. Do you have any idea how to solve the problem. Thank you in advance.

Greetings!

Re: pick data using generic load

Tue, 21 Apr 2015 10:42:22 GMT

The Problem was solved using

Match(DATANAME, Fieldname1,Fieldname2...)

topic Re: pick data using generic load in QlikView

pick data using generic load

Re: pick data using generic load