Loading Two Tables and marking duplicates

dmac1971 — Wed, 26 Nov 2014 15:41:32 GMT

Currently I load some data as follows :

Directory;

//Load Brand One Open Lines
_brand1tmp:
Customer,
Order_No,
Line_No,
Order_No & '-' & Line_No As Line_ID
Part_No,
Qty,
Value

FROM
[..\Sources\Brand1 Open Lines.xls]

[Brand 1 Lines]:

NOCONCATENATE LOAD
Customer,
Order_No,
Line_No,
Line_ID
Part_No,
Qty,
Value,

if (peek('Line_ID',-1) = Line_ID,'Dup','NoDup') as DupRec
RESIDENT _brand1tmp
ORDER BY Line_ID;

DROP TABLE __brand1tmp;

//Load Brand Two Open Lines
_brand2tmp:
Customer,
Order_No,
Line_No,
Order_No & '-' & Line_No As Line_ID
Part_No,
Qty,
Value

FROM
[..\Sources\Brand2 Open Lines.xls]

[Brand 2 Lines]:

NOCONCATENATE LOAD
Customer,
Order_No,
Line_No,
Line_ID
Part_No,
Qty,
Value,

if (peek('Line_ID',-1) = Line_ID,'Dup','NoDup') as DupRec
RESIDENT _brand2tmp
ORDER BY Line_ID;

DROP TABLE __brand2tmp;

However QV falls over at the end of the script. If I comment one of the sections out, ie only load Brand1 sales, its fine and duplicates are marked ok etc. What is it I am doing wrong here? Do I need to join the tables first, something I haven't had to do before.

Re: Loading Two Tables and marking duplicates

dmac1971 — Wed, 26 Nov 2014 15:44:11 GMT

Doh as soon as I posted it I got it figured, LOAD not NOCONCATENATE LOAD!

topic Re: Loading Two Tables and marking duplicates in QlikView

Loading Two Tables and marking duplicates

Re: Loading Two Tables and marking duplicates