Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Below code works for me on limited data set but on full load app throws Out of object Memory.
Is there better/optimize way to tackle below code?
Granularity of data is at month level and Join condition between two tables is below Composite Key.
without left join..numbers from Table 'ABC' are not giving the desired results..
Something that might be worth trying -
1) Store the Key field in the QVD directly rather than calculating it during the load
2) Use Where Exists Key in the QVD load
That would optimize the QVD load and reduce the rows immediately, which might help (and should be faster regardless).
1. Possible for you to share an example.
2. Using Where Exists doesn't give the right count from table 'ABC'
Please don't double-posting: optimize way to Join between two group by statemen... - Qlik Community - 2455080