3 Replies Latest reply on Nov 27, 2018 10:25 PM by Ombir Rathee

    Getting multiple records after join two database

    Vicktoria Safran


      My data sources for a workbook are from two different databases. The first database has all relevant table, but the second database has several tables from which I need data.

      When I load the first database and check SUM of sales (existing column in the database) I am getting the correct value.

      But once I joined the second database,  regardless of which join type I use, that value (SUM of sales) is incorrect (extremely inflated) probably due to duplication.

      It's unclear what I am doing wrong.