Hello,
I am trying to load the following script:
Fact:
Load
[AC_DOC_NO]&[FISCYEAR]&[COMP_CODE] AS key,
REPLACE(LTRIM(REPLACE("OI_EBELN",'0', ' ')), ' ', 0)&REPLACE(LTRIM(REPLACE("OI_EBELP",'0', ' ')), ' ', 0) AS [Purchase Order row/no]
FROM [source]
PO1:
LOAD
key,
if((IsNull([Purchase Order row/no]) or [Purchase Order row/no]= 0) and key= Previous(key), Peek('[Purchase Order row/no 1]'), [Purchase Order row/no]) as [Purchase Order row/no 1]
Resident Fact;
EXIT SCRIPT;
Now, when I only use [Purchase Order row/no] I get a total of 13 rows, but when I add [Purchase Order row/no 1] lots of duplicates are created.
Can someone please assist me on this.
