Skip to main content
Solved

Comparing values from two tables

  • May 16, 2023
  • 4 replies
  • 271 views
JTH
Star Blazer L1
Forum|alt.badge.img+2
  • JTHStar Blazer L1
  • Star Blazer L1

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 Ataccama Community Admin

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. 

N
A
A

4 replies

A
Forum|alt.badge.img+1

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
JTH
Star Blazer L1
Forum|alt.badge.img+2
  • JTHStar Blazer L1
  • Author
  • Star Blazer L1
  • May 23, 2023

Thank you!

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

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

A
A
Forum|alt.badge.img+1

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. 

Community Terms of Use & ConditionsCookie settingsAccessibility statement