Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SQ01 Query - Delete adjacent duplicates

Former Member

‎2008 Aug 14 5:48 PM

0 Likes
953

Hi,

We have a SQ01 query which is giving duplicate records in the output. We could not check the table joins conditions as it has a lot of table joined in it to bring the output.

Is there a possibility to delete the adjacent duplicates from the query output using the coding option in the query. The records get processed one by one and it is appended to %g00. This is not accessible in the coding enhancement part of the SQ02. Please let me know if the final output table of the query could be accessed and modified. Thanks.

Regards,

Prabaharan.G

Hi,

We have a SQ01 query which is giving duplicate records in the output. We could not check the table joins conditions as it has a lot of table joined in it to bring the output.

Is there a possibility to delete the adjacent duplicates from the query output using the coding option in the query. The records get processed one by one and it is appended to %g00. This is not accessible in the coding enhancement part of the SQ02. Please let me know if the final output table of the query could be accessed and modified. Thanks.

Regards,

Prabaharan.G

Reply
1 REPLY 1
Read only

RichHeilman
Developer Advocate
Developer Advocate

‎2008 Aug 14 6:03 PM

0 Likes
592

You need to determine what table join is causing the duplicate records. I have seen this when joining MARA, and MAKT together, where there are multiple languages, in that case, you would need to always select on one particular language in the selection screen of the query, this would then get rid of the duplicates. Of course this is one example, and probably not exactly your issue.

Regards,

Rich Heilman