Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

pick data using generic load

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!

1 Solution

Accepted Solutions
Not applicable

Re: pick data using generic load

The Problem was solved using

Match(DATANAME, Fieldname1,Fieldname2...)

1 Reply
Not applicable

Re: pick data using generic load

The Problem was solved using

Match(DATANAME, Fieldname1,Fieldname2...)

Community Browser