Skip to main content
Solved

Comparing values from two tables

JTH
Star Blazer L3
Forum|alt.badge.img+2
  • JTHStar Blazer L3
  • Star Blazer L3

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. 

View original
Feel free to move my post to the Ideas or Questions section—no need to ask me first.

    4 replies

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

      Thank you!

      Feel free to move my post to the Ideas or Questions section—no need to ask me first.
      Data Voyager
      Forum|alt.badge.img+1

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

        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 & ConditionsAccessibility statement