Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

The Problem was solved using

Match(DATANAME, Fieldname1,Fieldname2...)

View solution in original post

1 Reply
Not applicable
Author

The Problem was solved using

Match(DATANAME, Fieldname1,Fieldname2...)