Skip to Content
avatar image
Former Member

duplicate rows

hi,

can anyone tell me how to filter out duplicate rows....

thanks

karthick

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 25, 2007 at 07:01 PM

    Karthick,

    It is possible that you have a bad or are missing a table join in your query as well. If you add in this join it will perform better than a distinct.

    -Sam

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hi som,

      this will work when the number of columns is fixed.in my case the months(jan' 07,feb' 07....)are going to be the columns.in future the no. of columns is going to differ....so how we can do with that.....

      thanks

      karthick

  • avatar image
    Former Member
    Sep 21, 2007 at 07:54 AM

    In SQL, use "select DISTINCT..." instead of just "select"

    If you are in BLS there is a distinct value extractor you can use, or if you have a repeater action you can type something like this in the XPATH

    query.response{/bapi_name/table/item[not FIELDNAME = preceding-sibling::item/FIELDNAME]}

    Hope this helps

    Nick

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      In Sql u can use like this "select distinct(fieldname) from table name"

      it will retrive only non duplicate records

      Pls give points if u satisfy with answer

      Thanks

      Ramesh