This content has been marked as final. Show 2 replies
I have a table with the following contents:
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:
I am using the following script in my Load statement:
(There are like 10 more fields , but i want to focus only on the above)
Score as Innovation
where Performance Category = "1"
Outer Join (Ratings)
Score as Loyalty
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?