How to exclude records without using Exclusion activity

Forum|Forum|1 year ago
May 7, 2024
4 replies
1518 views

Hi Team,

We have a requirement based on a Boolean Flag we are excluding few records and in the Query conditions there are many links after which we query based on the Boolean's Flag Value.

In our current approach, there are 2 query activities with one having the condition [Schema1/Schema2/@Flag] equal to "Yes" and the other query having the condition [Schema1/Schema2/@Flag] equal to "No", then we are using an Exclusion activity and taking primary set as [Schema1/Schema2/@Flag] equal to "Yes" (1st query's Data) and excluding the 2nd query's records.

Example WF for 1 schema

This approach is done for nearly 40 schemas , which is causing issues and we are required to Optimize the Workflow and reduce the number of activities being used.

Could you Please suggest us the approach to use the single query instead of multiple query's and Exclusion activities

Regards,

Pravallika.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Heku_

Level 5

Hello @lakshmipravallika, as the schema you are querying is the same, you can put in the same query both conditions, but with [Schema1/Schema2/@Flag] not equal to "No".

Hope this helps.

Regards,

Heku

LakshmiPravallika

Author

Community Advisor

Hi @heku_ ,

We already tried this and its not working. We even tried using Except operator also, still no luck.

Regards,

Pravallika.

Manoj_Kumar

Community Advisor

@lakshmipravallika Try querying to schema2 directly and then change the dimension to schema 1 when you have the expected results.

Manoj Find me on LinkedIn

LakshmiPravallika

Author

Community Advisor

Hi @_manoj_kumar_ ,

We tried to query Schema 2 directly by changing the Filtering dimension to schema2 and used the Change dimension activity to change data back to schema1, still its not working.

Regards,

Pravallika.