1 Reply Latest reply on Apr 25, 2018 5:12 PM by Shinichiro Murakami

    Table Joins From Database

    mike.shaup

      We are trying to create a dashboard for my client to automate some of the departments reporting. I am trying to join these two tables (table 1 and table 2 below which contain dummy data) from a database but keep running into a problem where a join will pull in duplicates. I've tried blending the two tables but get the following error: "Oracle database error 1795: ORA-01795: maximum number of expressions in a list is 1000".

       

      Unfortunately, my client wants to use a live connection and I don't have a way to create/edit the tables from the database. I also cannot post the file/data I am working off of due to confidential information.

       

      Is there any way to pull in the position field into different columns like the table 3 provided?

       

       

      Table 1:

           

      IDCompanyFirst NameLast NamePosition
      90210Company AJohn DoeManager
      90210Company AJoeDonaldAnalyst
      90210Company AJaneBellVP
      90210Company AJosieHatterSVP
      90211Company BJonDellAnalyst
      90211Company BJakeDoManager

                 

       

      Table 2:

       

                                        

      ID
      Company
      Start Date
      Closing Date
      Category
      Close Reason
      90210Company A4/1/20184/25/2018SaleComplete
      90211Company B3/31/20184/4/2018SaleIncomplete

       

      Table 3:

       

            

      IDCompanyStart DateClosing DateCategoryClose ReasonAnalystManagerVPSVP
      90210Company A4/1/20184/25/2018SaleCompleteJoe DonaldJohn DoeJane BellJosie Hatter
      90211Company B3/31/20184/4/2018SaleIncompleteJon DellJake Do