Skip to main content
Solved

Comparing values from two tables

JTH
Data Pioneer
Forum|alt.badge.img+2
  • JTHData Pioneer
  • Data Pioneer

Hi,

Situation: I wrote a(n) SQL catalog item joining multiple tables and in Ataccama I'm using rules to compare the values if they are the same. LONG = LONG, check if the nr_loan = the same a.nr_loan, etc.

My question is if there's an easier way to see if two tables are identical. I'm doing this to check the integrity.

I couldn't find anything relatable asked in the community.

 

 

Best answer by Cansu

Hi @JTH, thank you for posting! Currently, the only way to compare two tables is to join them in a VCI and apply cross-attribute checks or with an SQL CI as you’ve described as your current practice. 

View original

Cansu
Community Manager
Forum|alt.badge.img+3
  • CansuCommunity Manager
  • Community Manager
  • May 22, 2023

Hi @JTH, thank you for posting! Currently, the only way to compare two tables is to join them in a VCI and apply cross-attribute checks or with an SQL CI as you’ve described as your current practice. 

Check out our Quick Start Guide to get started on the community 🙋‍♀️
JTH
Data Pioneer
Forum|alt.badge.img+2
  • JTHData Pioneer
  • Data Pioneer
  • May 23, 2023

Thank you!

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

Is there a chance that this table level comparison is possible in near future versions of ataccama?

Cansu
Community Manager
Forum|alt.badge.img+3
  • CansuCommunity Manager
  • Community Manager
  • June 20, 2023

Hi @GopichandG, the team is aware of this feedback, and we’ll be sure to let you know in the monthly updates. We are releasing monthly product updates where you can find out about all our recent updates. 

Check out our Quick Start Guide to get started on the community 🙋‍♀️

Reply


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