Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi,
You have to put before the LOAD Add OR Replace, to the partial reload works.
Best Regards
Tonial
Hi Sir
Thank for spot my mistake. Bit I not understand what you mean can you write a bit more ?
Paul
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.
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