Peek function for more than one dimension

[#1]

Hi,

I am trying to create values for every number in my table using the peek function. It's working with only one dimension but not with two. This is my input:

LOAD * INLINE [

    No, Item, Value

    1, A, 100

    1, B, 50

    4, A, 200

    4, B, 300

    5, A, 99

    5, B, 400  

];

and I want the output to look like this:

No	Item	A	B
1		100	50
2		100	50
3		100	50
4		200	300
5		99	400
6		99	400

I have tried with the following script:

NumberTable:

Load RecNo() as No

AutoGenerate (6);

Left join

LOAD * INLINE [

    No, Item, Value

    1, A, 100

    1, B, 50

    4, A, 200

    4, B, 300

    5, A, 99

    5, B, 400  

];

//NewTable:

NoConcatenate

Load No,

     if(IsNull(Item),Peek(Item),Item) as Item,

     if(IsNull(Value),Peek(Value),Value) as Value

Resident NumberTable

Order by No, Item Asc;

Drop Table NumberTable;

But the peek function is only working for Item B:

No	Item	A	B
1		100	50
2		-	50
3		-	50
4		200	300
5		99	400
6		-	400

[sunny_talwar]

Try this:

NumberTable:

Load RecNo() as No

AutoGenerate (6);

Left Join (NumberTable)

LOAD * Inline [

Item

A

B

];

Left join

LOAD * INLINE [

    No, Item, Value

    1, A, 100

    1, B, 50

    4, A, 200

    4, B, 300

    5, A, 99

    5, B, 400 

];

NewTable:

NoConcatenate

Load No,

     Item,

     if(IsNull(Value),Peek(Value),Value) as Value

Resident NumberTable

Order by Item, No;

DROP Table NumberTable;