Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have recently upgraded QV Desktop and QV server from V11 to V12.
I have noticed a really strange behaviour While re-loading documents.
Problem : When I use Left Join Load, then it loads everything from the second table instead of loading matching data.
Example Script
Load OrderID,
CustomerID,
OrderStatusID
From Order.QVD
WHERE OrderStatusID = '2' ; // this is only loading completed orders //
Left Join Load CustomerID,
CustomerName
FROM Customer.QVD ;
So in this script.. Only those customers will be loaded which exists in the order table.. but instead of that.. it is loading every customer from the customer table.
In Version 11 it was working fine but I have no idea why its loading every row from Customer Table.
Am I doing anything wrong ?
Could you post a small representative qvw that demonstrates the issue?
It really Strange !!! I never faced such things
could please share sample data and your complete script ?? so that we can help you out
Hi,
Try
Customers:
Left Keep(Orders)
LOAD
*
FROM Customer.QVD ;
Regards,
jagan.
Hi Guys,
I have tried Left Keep too..
I am unable to share that qvw due to the data being confidential but I will replicate the script and data-model and upload it here tomorrow.