Skip to main content
Solved

Comparing values from two tables


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

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
Did this topic help you find an answer to your question?

4 replies

Cansu
Community Manager
Forum|alt.badge.img+3
  • Community Manager
  • 635 replies
  • Answer
  • 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. 


JTH
Data Pioneer
Forum|alt.badge.img+2
  • Author
  • Data Pioneer
  • 16 replies
  • May 23, 2023

Thank you!


Forum|alt.badge.img+1
  • Data Voyager
  • 1 reply
  • June 12, 2023

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
  • Community Manager
  • 635 replies
  • 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. 


Reply


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