first and last record of table

[#1]

ID SOUR DES

111 BOM DEL
111 DEL DBR
111 DBR LHR
222 BOM LUK
222 LUK PAK
222 PAK WC



We want result

id sour des
111 BOM LHR
222 BOM WC

how can we pick first and last record of column plz help me urgent basic

Regards

Ashish

[#2]

Hi Ashish

Based on data and information provided.

Please see attached qvw.

I think you need to be more specific how you detemine 1st record and last record for each ID.

[boorgura]

You can do that in the script:

you can use

FIRST <n> (in your case FIRST 1)

LOAD ....

FROM ...

and for the last you can do a FIRST 1 load again...

But before that in the load wizard you will have to Rotate the data left/right twice, so that the data goes up-side-down.