Load Script acting crazy after upgrade to QV12

[#1]

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 ?

[tresesco]

Could you post a small representative qvw that demonstrates the issue?

[avinashelite]

It really Strange !!! I never faced such things

could please share sample data and your complete script ?? so that we can help you out

[jagan]

Hi,

Try

Customers:

Left Keep(Orders)

LOAD

*

FROM Customer.QVD ;

Regards,

jagan.

[#5]

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.