#2 Ability to use distinct

[Aymkam]

Hello, thanks a lot for developing the Sap Extract tool, it's really handy with lots of good features.

Just wanted to know whether it's possible to use a distinct feature to remove duplicates when retrieving data?

I noticed there's a Group tab but I think it's different from the 'Group By' Keyword that is used in Sql to remove duplicates!

Best regards,
Aym

[George Borghouts]

Hi Aym, many thanks for your message and kind words. Much appreciated.

Your question is a very valid one, in standard SQL using the "distinct" and/or "group by" clauses (as well as some other clauses like e.g. "order by") are all normal and accepted. In SAP SQL those can also be used but unfortunately the function module rfc_read_table (which is what ExtracTable connects to in your selected SAP system) does not allow such SQL clauses to be used.
SAP's rfc_read_table function module is thus rather limited.

Indeed instead of using "distinct" one could reach the same result of removing duplicates via "group by" on relevant selected fields, but even "group by" is thus not possible in SAP's rfc_read_table. The Groups tab in the ExtracTable tool stands apart from SQL like you mention, it was built to define groups of (filtered)tables that need to be donwloaded in a sequential manner.

Hopefully one day SAP updates their rfc_read_table function module so that it can also process more clauses like these above. If so I will update it here as well!

Would be great if you can put your review score on the tool here on https://sourceforge.net/projects/extract-table-for-sap/reviews/

Have a great day and hoping writing to you again!
Cheers,
George

[George Borghouts]

I just published version 3.8 . Under settings it now also has the option to remove all duplicate rows before creating its output.

It still will download the (filtered)table as a whole, but at least you now can get the duplicates removed before your Excel orCSV is generated.

[Aymkam]

Hi George, 
Thanks a lot for the update, I'll give it a go soon 👍

Sent from Yahoo Mail on Android

On Fri, 25 Aug 2023 at 16:20, George Borghoutssoxap@users.sourceforge.net wrote:
I just published version 3.8 . Under settings it now also has the option to remove all duplicate rows before creating its output.

It still will download the (filtered)table as a whole, but at least you now can get the duplicates removed before your Excel orCSV is generated.

**[tickets:#2] Ability to use distinct **

Status: open
Milestone: 1.0
Created: Thu Jul 20, 2023 01:58 PM UTC by Aymkam
Last Updated: Tue Aug 08, 2023 05:39 PM UTC
Owner: George Borghouts

Hello, thanks a lot for developing the Sap Extract tool, it's really handy with lots of good features.

Just wanted to know whether it's possible to use a distinct feature to remove duplicates when retrieving data?

I noticed there's a Group tab but I think it's different from the 'Group By' Keyword that is used in Sql to remove duplicates!

Best regards,
Aym

Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/extract-table-for-sap/tickets/2/

To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/