Loading Two Tables and marking duplicates

[dmac1971]

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.

[dmac1971]

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