How to perform Partial Reload with Left Join on Qlik?

[user42_qlik]

I have a Qlik script where I load two tables, Product and Customer. I join these two tables on a common field called Purchase_ID using a left join. I want to do a partial reload on the Customer table using the Partial Reload button to see the updates when new customers are added to the Customer table. However, this does not update my sheet when the Partial Reload option is selected as shown below: 

I tried using the ADD ONLY LOAD option but this requires me to click the Reload button each time I load the dashboard, else I get an Incomplete Visualization error as it loads the Customer table only when a Partial Reload is initiated. I also tried using an if PartialReload = 0 then ... endif condition for the Product table but I get a No Table to Join error.

How can I do a Partial Reload in this situation? Here is my script for reference:

LOAD 
    Product_ID, 
    Cost_Per_Unit, 
    Purchase_ID,
    Date
FROM Product
WHERE Date > '2023-06-01'

LEFT JOIN

ADD LOAD 
    Customer_ID, 
    Purchase_ID
FROM Customer

[Digvijay_Singh]

Looks like partial reload and join don't work properly as per this support article - 

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Partial-reload-does-not-work-with...