on 09-21-2007 7:07 AM
hi,
can anyone tell me how to filter out duplicate rows....
thanks
karthick
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ahamed
<b>Distinct Value Extrator Action</b> is just only for extracting the distinct values in <b>one column</b>, NOT the rows in the whole XML dataset.
Karthik
I think u need to make some combined or custom actions to get distinct rows from the XML which will lead exhausting hands with logical complexity (by using Repeater, Conditional, Assignment to Local variables, Resetting etc), since there is no such defined single Action Block in BLS for getting distinct rows from an XML Dataset
Regards
Som
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
7 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.