Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView Resident Load is too slow

Hi There,

My Scenario:

I have a table with the following contents:

IDCategory IDCategoryScore
1221InnovationExcellent
12212LoyaltyExcellent
12215OverallAverage

And my task is to have this data converted into one row , so that we can perform our analysis, the table should look like this:

IDInnovationLoyaltyOverall
122ExcellentExcellentAverage

I am using the following script in my Load statement:

RawData:

Load

ID,

Category ID,

Category,

Score,

(There are like 10 more fields , but i want to focus only on the above)

From Table

Ratings:

Load

ID,

Score as Innovation

Resident RawData

where Performance Category = "1"

Outer Join (Ratings)

Load

ID,

Score as Loyalty

Resident RawData

where Performance Category = "12"

I do this for around 10 categories and for the first 2-3 my loading time is around 24 seconds , but as soon as i start to add more categories my whole pc crashes or if i leave it the loading time is around 5-6 hours which is something that is unacceptable for my client.

The first table that i am loading has around 300 000 rows of data.

Is there a workaround where I can get what i need , but to reduce the loading time in general?

Many Thanks,

Atanas

1 Solution

Accepted Solutions
Gysbert_Wassenaar

I don't understand why you need to transform the data to the second format. But if you insist on that kind of data model then try using a Generic load: The Generic Load


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

I don't understand why you need to transform the data to the second format. But if you insist on that kind of data model then try using a Generic load: The Generic Load


talk is cheap, supply exceeds demand
Not applicable
Author

You sir, are my saver!

Thank you , very much