Using Peek and Previous creating duplicates rows

[extbhoslpr]

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.

[Sabrina_V]

Peek - fonction de script | Aide Qlik Sense sous Windows . Please see the link : here