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.
