Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
robindc
Contributor
Contributor

Load Editor stuck on 'Starting to load'

Hi!

 

I've ceated a QVD containing about 194M records and about 11 columns.

Now, I want to load this QVD in the data load editor and build some logic on it. 

This is the code I would like to execute:

TRANS_FLAGS_UNIQUE:

LOAD 
     Min(ACTIONDATE) as Date,
     Year,
     Month,
     Day,
     Hour,
     CAMPAIGNID,
     ACTIONID,
     PROBEID,
     USERID,
     SUM(Opened) as Unique_Opened,
     SUM(Clicked) as Unique_Clicked,
     SUM(Optout) as Unique_Optout
FROM [lib://Manual Data Shared Folder/rdeconin/CRM RMD Campaign Analysis/QVD/RAW_F_RAWFLAGS.qvd]
(qvd)
group by CAMPAIGNID, ACTIONID, PROBEID, USERID;

join

TRANS_FLAGS_ALL:

LOAD 
     Min(ACTIONDATE) as Date,
     Year,
     Month,
     Day,
     Hour,
     CAMPAIGNID,
     ACTIONID,
     PROBEID,
     FLAGID,
     USERID,
     SUM(Opened) as All_Opened,
     SUM(Clicked) as All_Clicked,
     SUM(Optout) as All_Optout
FROM [lib://Manual Data Shared Folder/rdeconin/CRM RMD Campaign Analysis/QVD/RAW_F_RAWFLAGS.qvd]
(qvd)
group by CAMPAIGNID, ACTIONID, PROBEID, USERID,FLAGID;

When I start the data load, it keeps saying: 'Started loading data'.

How can I fix this? When I load in the QVD without any additional logic, it takes around 3 minutes.

 

Thanks!

Labels (2)
0 Replies