Need only one row

[Srinivas]

Hi All,

I need only one row in this screen shot in edit script level.

How to do Could you please help on this.

Warm Regards,

Munna

[MarcoWedel]

Can't open link, please include image in your post.

[ecolomer]

Can you explain more about your nedds?, please

[Srinivas]

Hi Marco,

Thanks for your response in my screen shot have two rows, So in that we need only one row,Here have all columns(Rows Values) are same expect PROD_DESC. in that PROD_DESC we need only one row values...

in my script level i used maxstring function but it's not work.

Regards

Munna

[MarcoWedel]

can you post a sample app?

[#6]

hey Munna..

Nor your screenshot is visible neither is your question very clear..

you want only one row to appear out of 2 rows ?

or for a specific column , you want only one row data to appear... ?

[anbu1984]

Group by all the fields except PROD_DESC

Load Field1,Field2,MaxString(PROD_DESC) As PROD_DESC Group By Field1,Field2;

Load * Inline [

Field1,Field2,PROD_DESC

1,A,aaa

1,A,bbb

1,B,aaa

1,B,bbb ];