topic Re: Missing records while Updating in QlikView

Missing records while Updating

ganeshreddy — Thu, 26 Nov 2015 15:49:36 GMT

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

Re: Missing records while Updating

maxgro — Thu, 26 Nov 2015 15:59:37 GMT

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;

Re: Missing records while Updating

ganeshreddy — Fri, 27 Nov 2015 06:15:21 GMT

Thank You Maxgro.