Partial reload script return zero

[#1]

Hi All

I have below script , it return zero for PRICE_LIST field.

left join

(PRICE)

Load PART_NO_,

    'USD '& LIST_PRICE as PRICE_LIST

Resident PRICE;

Take note :-

For testing , pls unzip the file to folder = C:\GE

[fernando_tonial]

Hi,

You have to put before the LOAD Add OR Replace, to the partial reload works.

Best Regards

Tonial

[#3]

Hi Sir

Thank for spot my mistake. Bit I not understand what you mean can you write a bit more ?

Paul

[fernando_tonial · Accepted solution]

Hi, you can try this.

You can't SUM a field with text.

load *, 'USD '& LIST_PRICE as PRICE_LIST from $(vQVDPath)BECKHOFF.qvd (qvd);



Concatenate 



load *, 'USD '& LIST_PRICE as PRICE_LIST from $(vQVDPath)HAKKO.qvd (qvd);



Concatenate 



load *, 'USD '& LIST_PRICE as PRICE_LIST from $(vQVDPath)MITSUBISHI.qvd (qvd);



Concatenate 



load *, 'USD '& LIST_PRICE as PRICE_LIST from $(vQVDPath)GE.qvd (qvd); 

Best Regards.

Tonial.

[#5]

Hi Sir

Thank you very much , your offer help me a lot .

Now i manage to make partial reload working fine.

And i can move on to get all other value cal out.

Paul