topic Re: Remove duplicate values in Query AA tables in Application Development and Automation Discussions

Remove duplicate values in Query AA tables

former_member615468 — Tue, 09 Nov 2021 13:27:27 GMT

Hello,

i'm creating a query report and trying to join tables ANLA ,ANLB, ANLC, ANLP and ANLZ but i got duplicate output entries.

can anyone please explain to me why i got these duplicate values and how can i delete them?

thanks.

Re: Remove duplicate values in Query AA tables

vijay_hariharan — Tue, 09 Nov 2021 13:45:26 GMT

Hi Mohamed,

The output from the Query would depend on the conditions you have given while querying on the various Asset tables. Would be rather difficult for someone to help you without knowing the query n conditions you have used. Would suggest taking help from someone around you who could assist you with the condition used. You may post the conditions here, maybe an expert here could offer help.

All the Best!

Regards,
Vijay

Re: Remove duplicate values in Query AA tables

TammyPowlas — Tue, 09 Nov 2021 13:48:12 GMT

I agree with Vijay's comments

Also before joining tables, I recommend looking at logical database ADA to see if it meets your needs. SAP provides SAP query examples in user group AM (see SQ01, user group AM):

Re: Remove duplicate values in Query AA tables

former_member615468 — Tue, 09 Nov 2021 15:26:28 GMT

hello Vijay,

thanks for the reply, the join is defined in the screenshot.

a coding is necessary to remove the duplicate values?

thanks.

join-tables.png

Re: Remove duplicate values in Query AA tables

former_member615468 — Tue, 09 Nov 2021 15:27:52 GMT

table-data.png