filtering

[janardhan]

Hi friends ,

please find the attachement , here is the Objectid is repeated so i need to eliminate the repeated one ,  my requirement is

ObjectID                WSTYPE             QTY

OTG115120A001      Normaltid         27

I need like this

[#2]

Hai,

Use distinct of ObjectID  ,Sorry if i didnt understand you correctly.

Thanks

[jagan]

Hi Janardhan,

Can you attach the sample file with data?

Regards,

Jagan.

[#4]

Hai,

Plese use the distinct function for id

distinct(object id)

[MayilVahanan]

Hi

Are you looking like this

Load * Inline

[

ObjectID,WSTYPE,QTY

OTG115120A001,Normaltid,27

OTG115120A001,Normaltid,

OTG115120A001,Normaltid,

OTG115120A001,Normaltid,

] where Len(Trim(QTY)) > 0;

in script??

its load where qty has value only

[vgutkovsky]

Well, the simple answer is that you're using a Table Box when you probably want a Straight Table. Create a Straight Table with dimensions ObjectID and WSTYPE and expression sum(QTY)

Regards,

Vlad