2 Replies Latest reply on Jun 19, 2018 11:16 PM by Mahfooj Khan

    Create multiple data sources from single database connection.

    Laura Zhang

      Hi,

       

      I have a Microsoft SQL database that contains 6 tables, I need 3 of them join together for my worksheet, however, I also need join them again (use a different key to join) to get my other worksheet calculation works. I am trying to connect to the database again, so in my datasource, it shows 2 connections, but when I edit each of it, I have to join the table as same. Is is possible i can have two connections to the same database, and also edit them differently.

       

      Thanks a lot!