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

[#1]

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 · Accepted solution]

Table2:

noconcatenate

Load ID, firstvalue(Value) as FirstValue

resident Table1

group by ID;