Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
As you are using (delimiter is '|') on the T1 Load statement just replace ID,Value with ID | Value
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 '|');