Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi everyone
i have this master files and they are daily added into this folder
i have done incremental on this by the help of @rwunderlich
script is :-
master:
LOAD
*,
RecNo() as RecId
FROM
[..\material master and customer master txt\MAT_MAS_20190731_131746.txt]
(txt, codepage is 1252, embedded labels, delimiter is '|', msq) ;
Inner Join(master)
LOAD EAN, Max(RecId) as RecId
Resident master
Group by EAN
;
DROP FIELD RecId;
now i want to implemet this script in loop so that all files get loaded one by one and compare with each other and load all data in it.
so my question is suppose first file in image have ean id of 1001010 and mrp is 100 , and last file with same ean have mrp of 200 , so it should load 200 mrp.
hope you get my querry.
Just two changes -- shown in bold -- I would make to the first LOAD statement:
master:
LOAD
*,
RowNo() as RecId
FROM
[..\material master and customer master txt\MAT_MAS*.txt]
(txt, codepage is 1252, embedded labels, delimiter is '|', msq) ;
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
Just two changes -- shown in bold -- I would make to the first LOAD statement:
master:
LOAD
*,
RowNo() as RecId
FROM
[..\material master and customer master txt\MAT_MAS*.txt]
(txt, codepage is 1252, embedded labels, delimiter is '|', msq) ;
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com