Distinct without Sum or Count

[psk180590]

Hello All,

I'm looking to find out if there is any possibility to get Distinct of a Column and Store it as Another Column without using any aggregation Values such as Sum or Count.

Say i have the following ID's:

ID
FB1
FB2
FB1
FB6
FB7
FB8
FB5
FB4
FB6
FB9
FB3

I need to generate another Column at the Script level using Distinct of this values:

Distinct ID
FB1
FB2
FB6
FB7
FB8
FB5
FB4
FB9
FB3

Thanks.

Sai

[teiswamsler]

hi Pakalapati

Try this

Table2:

Load distinct

     ID as "Distinct ID"

Resident Table 1;

/Teis

[Akina0929]

Hi sai kumar,

  use first value function in script.

load

firstvalue(id) as id

from..........

thanks