Getting Error

[Anonymous]

Hi,

When i am trying to run the below code.

T1:

LOAD * inline [

ID, Value

1|3

1|4

1|6

3|7

3|8

2|1

2|11

5|2

5|78

5|13

] (delimiter is '|');

T2:

LOAD

*,IF(ID=Peek(ID), Peek(List)&','&Value,Value) AS List

RESIDENT T1

ORDER BY ID ASC;

DROP TABLE T1;

I am getting Field not found for Script Error for T2 table..

Thanks in Advance..

[albertovarela]

As you are using (delimiter is '|') on the T1 Load statement just replace  ID,Value   with ID | Value

[vishsaggi]

As alberto suggested try like below:

T1:

LOAD * inline [

ID| Value

1|3

1|4

1|6

3|7

3|8

2|1

2|11

5|2

5|78

5|13

] (delimiter is '|');