topic Getting Error in QlikView

Getting Error

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 22 Jun 2018 16:01:10 GMT

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

vishsaggi — Fri, 22 Jun 2018 16:17:04 GMT

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 '|');