Skip to main content
Solved

Apply rules only to newly created records through any filter

  • February 4, 2025
  • 2 replies
  • 35 views
B
Universe Traveller

Hi,

Could anyone help me on below scenario. I am using Ataccama ONE web 14.4. 

Millions of records are populated in testing environment from Production real time data. However , for testing purpose manipulated few 1K records. Is there any way in Ataccama where we can apply rules and perform “Monitoring Projects” only to the new records 1K created by giving any date created filter?

 

Regards,

Bhuvi

Best answer by anna.spakova

Hi ​@Bhuvaneshwari Balasubramaniam, in your current version, you might need to create either SQL catalog item or Virtual catalog item to filter out the values (you can se some dynamic filter by using the today() or similar functions to always get the new records).

https://docs.ataccama.com/one/14.5.x/catalog-items/sql-catalog-items.html

https://docs.ataccama.com/one-desktop/14.5.x/work-with-ataccama-one/virtual-catalog-items.html

In the recent version 15.4 it is possible to use Data Slices, where you can specify the filter directly on the Catalog Item. If possible, I recommend you consider upgrading.

https://docs.ataccama.com/one/latest/catalog-items/create-data-slice.html

Let me know if this answers your question.

 

Kind regards,

Anna

View original
Did this topic help you find an answer to your question?

anna.spakova
Ataccamer
Forum|alt.badge.img+3

Hi ​@Bhuvaneshwari Balasubramaniam, in your current version, you might need to create either SQL catalog item or Virtual catalog item to filter out the values (you can se some dynamic filter by using the today() or similar functions to always get the new records).

https://docs.ataccama.com/one/14.5.x/catalog-items/sql-catalog-items.html

https://docs.ataccama.com/one-desktop/14.5.x/work-with-ataccama-one/virtual-catalog-items.html

In the recent version 15.4 it is possible to use Data Slices, where you can specify the filter directly on the Catalog Item. If possible, I recommend you consider upgrading.

https://docs.ataccama.com/one/latest/catalog-items/create-data-slice.html

Let me know if this answers your question.

 

Kind regards,

Anna

B
Universe Traveller

Hi Anna,

Thank you for the response.

 

Cansu
1 person likes this
  • Cansu
    Cansu

Reply


Most Liked this week

Community Terms of Use & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings