Missing records while Updating

[ganeshreddy]

Hi All,

Here i need to update the new records to old file, while updating with this code i am missing  '201510,123,20,25' record. How resolve this issue,Here i got only four fields YearMonth, code, mat1, mat2 . Can any one help me on this. Please find attached.

Best Regards,

Ganesh

[maxgro · Accepted solution]

Data:

LOAD Date,

     code,

     mat1,

     mat2

  , Date & '-' & code as key

FROM

[New.txt]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

;

Concatenate

LOAD Date,

     code,

     mat1,

     mat2

FROM

[Old.txt]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

Where not Exists(key, Date & '-' & code);

drop field key;

[ganeshreddy]

Thank You Maxgro.