1 Reply Latest reply on May 30, 2018 10:04 AM by Isaac Kunen

    using multiple connections and joining

    Scott Strool

      I have not been able to find out how/if the current version of Prep can join from a database server (Redshift) to Microsoft Excel sheets.

      I can create a new flow with two connections but cannot add sheets to the workspace after I have previously added Redshift tables.

       

      Current limitation or misunderstanding the workflow?

       

      Thanks

        • 1. Re: using multiple connections and joining
          Isaac Kunen

          Hi Scott,

           

          You should absolutely be able to do this...

           

          Can you walk us through what you're trying to do step-by-step? Are you able to add both the Excel sheets and Redshift tables individually, just not in combination?

           

          I did just try a join between Excel and Redshift here, and it works for me. That doesn't rule out the possibility of a bug though, but I don't quite understand where int he workflow you're having a problem.

           

          Thanks!

          -Isaac

          1 of 1 people found this helpful