Given the large size of your data, using JOIN or ApplyMap() might lead to an 'Out of Object Memory' error in Qlik Sense. Instead, you can use INTERVALMATCH which is more memory-efficient for large datasets. Here's how you can modify your script:
ABC:
LOAD
AutoNumberHash128(Month, Cust_ID, Brand) as Key,
Month,
Status,
Brand,
TOTAL_CUSTOMERS;
SQL select
distinct Cust_ID,
Month,
Status,
Brand,
Count(distinct Cust_ID) TOTAL_CUSTOMERS
from table1
Group by 1,2,3,4;
XYZ:
LOAD
AutoNumberHash128(Month, Cust_ID, Brand)as Key,
Brand as Brand_XYZ,
Expected_Cust
FROM XYZ.qvd(qvd);
// Use IntervalMatch to link the tables
LinkTable:
IntervalMatch(Key)
LOAD Key
RESIDENT XYZ;
JOIN(LinkTable)
LOAD Key
RESIDENT ABC;
In this script, IntervalMatch creates a link table that connects the Key fields from both ABC and XYZ. This way, you can get the fields Status, Brand, TOTAL_CUSTOMERS from table 'ABC' into table 'XYZ' without running into memory issues.
Please replace the SQL statement with the appropriate data loading statement for your environment. Also, remember to replace `table1` and `XYZ.qvd` with your actual table name and QVD file path, respectively.
Remember to drop the `LinkTable` after you are done with it to free up memory. You can do this by adding `DROP Table LinkTable;` at the end of your script.
Please note that this solution assumes that the `Key` field uniquely identifies each record in both tables. If that's not the case, you might need to adjust the script accordingly.
If you're still having trouble, I recommend reaching out to Qlik Support or the Qlik Community for further assistance.
