incremental load on txt file without date field.

[riishabhz]

hello everyone

my txt file looks like this and link is here as they are not allowing me to attach txt file.

https://drive.google.com/file/d/1DlQW8Sc4h0JRmLu5diIgsV8b4lH1dhIr/view?usp=sharing

use delimater as this | pipe sign  

please help me to do incremental and update the records on the basis of ean which is the column after MGRP4DESC column.

please help me i am in need.

i searched everywhere but didnt got solution.

[dplr-rn]

My friend i am at a full time job. But i am trying to help but unfortunately i cannot write the whole thing for you.

For your learning i would suggest you try the approach suggested. Where you are going wrong i will be able to help.

can you answer my questions from previous reply

[rwunderlich]

How about:

Master:
LOAD *
FROM
[..\Downloads\MasterFile.txt]
(txt, codepage is 28591, embedded labels, delimiter is '|', msq);

Concatenate (Master)
LOAD *
From Master.qvd (qvd)
Where not exists(EAN)
;

STORE Master into Master.qvd (qvd);

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[riishabhz]

Ok sir thanx will try tomorrow morning and will update you 🙂

[riishabhz]

yes sir its working but its not updating the value .

like this example 

ean | price

1|10

1|20

qlikview should show ean 1 price as 20 because its updated value, but instead of updating it is adding and showing 30

what should i do now?

[rwunderlich]

Did you include the:

Where not exists(EAN)

Can you post your script?

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[riishabhz]

Yes sir i did include it, just same example that you gave.

[riishabhz]

here is my script:-
master:
LOAD MATERIAL,
COLOR,
SIZE,
[Size Group],
Description,
COMPOSITION,
BRANDCD,
BRAND,
SEASON,
SEASONDESC,
THEME,
DELYCODE,
GENDER,
ProductHierarchy,
MaterialGroup,
[Core/Fashion],
FIT,
PATTERN,
[Key/NonKey],
RANGE,
ORIGIN,
[Top/Bottom],
SLEEVE,
NECK,
WEATHER,
OCCASSION,
CustomDesc,
MaterialGrp4,
MGRP4DESC,
EAN,
ALTEAN,
PurchaseGroup,
PurchaseGroupDesc,
CATEGORY,
SUBCAT,
BASECOMP,
MaterialType,
ValuationClass,
COST,
MRP,
ChangeDt
FROM
[..\material master and customer master txt\MAT_MAS_20190731_131746.txt]
(txt, codepage is 1252, embedded labels, delimiter is '|', msq) ;

Concatenate(master)
LOAD MATERIAL,
COLOR,
SIZE,
[Size Group],
Description,
COMPOSITION,
BRANDCD,
BRAND,
SEASON,
SEASONDESC,
THEME,
DELYCODE,
GENDER,
ProductHierarchy,
MaterialGroup,
[Core/Fashion],
FIT,
PATTERN,
[Key/NonKey],
RANGE,
ORIGIN,
[Top/Bottom],
SLEEVE,
NECK,
WEATHER,
OCCASSION,
CustomDesc,
MaterialGrp4,
MGRP4DESC,
EAN,
ALTEAN,
PurchaseGroup,
PurchaseGroupDesc,
CATEGORY,
SUBCAT,
BASECOMP,
MaterialType,
ValuationClass,
COST,
MRP,
ChangeDt
FROM
[..\qvw file\qvd file\master1.qvd]
(qvd)Where not exists(EAN);

STORE master into [..\qvw file\qvd file\master1.qvd](qvd);

see photos , in excel i updated the value from 999 to 100 but qlikview is showing both the data , i want qlikview to show me 100 in data

[rwunderlich]

So your txt file has both the old and the new values for the same EAN?  And you want the last value in the file?

-Rob

[riishabhz]

Yes sir, i want only new value to be shown in records

[rwunderlich · Accepted solution]

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;

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com