topic How create table with only one value by ID ???? in QlikView

How create table with only one value by ID ????

Wed, 12 Jun 2013 10:43:40 GMT

Hello everybody !

TABLE1:

ID, VALUE

1, A

1, B

1, C

2, D

2, A

3, X

3, T

How can i create a table with only this:

1 , A

2, D

3 , X

Many thanks....

Fabien

Gysbert_Wassenaar — Wed, 12 Jun 2013 10:46:40 GMT

Table2:

noconcatenate

Load ID, firstvalue(Value) as FirstValue

resident Table1

group by ID;