how to get first occurrence values from the field?

[Akina0929]

Hi,

   I have a table that consist columns like

productid , productname

001,           chairs

002,           chairs

003,           chairs

004,            cots

005,            cots

006,            tables

007,            tables

I need output like below

productid, productname

001,          chairs

004,           cots

006,            tables

thanking you,

[sushil353]

Hi,

Try this:

LOAD *

where key  =1;

LOAD AutoNumber(productid,productname) as key, * Inline

[

productid , productname

001,           chairs

002,           chairs

003,           chairs

004,            cots

005,            cots

006,            tables

007,            tables

];

HTH

Sushil

[Anil_Babu_Samineni · Accepted solution]

Or Front-End this?

Create straight table

Dim as productid

Expression is --> FirstSortedValue(productname,Aggr(Sum(productid),productname))