Skip to main content
Solved

Exclude attributes from Reconciliaton Project

jdordregter
Data Voyager
Forum|alt.badge.img+1

Hi, 

we are making use of reconciliation projects to compare two different dataset with eachother. Most of the data needs to be compared, but some fields we want to skip in the comparison. 

  1. is it possible to skipp certain attributes in the comparison (we got some mutation date fields that show differences, but are no importance)
  2. is it possible to distinguish in notification between some attributes missing and data showing differences (Dataset A has a few extra attributes then Dataset B, but all other data should be exactly the same). I don't want daily notifications that I am missing these attributes, but I do want a notification when the data is showing differences.

kind regards, Jur Dördregter

Best answer by ekaterina.ponomareva

Hello!

Thank you for your question!

During the mapping process, you can manually select which attributes from the origin and target datasets you want to map. By doing this, you can exclude attributes that you do not want to compare. Make sure you uncheck automapping option.


If the project is already created, please go to ‘Results’ page, get to the ‘Compare’ tab and delete/add attributes, as needed. 


I believe this would solve both of the questions you have.

Let me know if you have any more questions.

Kind regards,
Ekaterina

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

E
Ataccamer

Hello!

Thank you for your question!

During the mapping process, you can manually select which attributes from the origin and target datasets you want to map. By doing this, you can exclude attributes that you do not want to compare. Make sure you uncheck automapping option.


If the project is already created, please go to ‘Results’ page, get to the ‘Compare’ tab and delete/add attributes, as needed. 


I believe this would solve both of the questions you have.

Let me know if you have any more questions.

Kind regards,
Ekaterina

jdordregter
Data Voyager
Forum|alt.badge.img+1

Thanks Ekatarina, that works! However this process also could have some improvements. I don’t want to map 65 attributes manually per table, that is quite time consuming. Removing attributes results seems to go faster, however the pop-up closes after every delete, the attribute page number is not remembered and I have to confirm every delete. So deleting 7 attributes requires me to open the pop-up 14 times and with 65 attributes, no sorting or search option I need to navigate trough the attribute pages a lot.

E
Ataccamer

Hi ​@jdordregter ,

Thanks a lot for your feedback. Please note, that you can also share your ideas and feedback here  - https://community.ataccama.com/ideas?

 

Kind regards,
Ekaterina

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