7 Replies Latest reply on Feb 25, 2017 2:26 PM by Jim Dehner

    Help! 3 datasets, how to connect them ? - newbie

    carlo.lupoi

      Dear all,

       

      I have 3 excel files:

      Sales.xlsx

      Salesbyzone.xlsx

      Databyzone.xlsx

       

      The first thing i did is to split the coloumn "startdatatime" into two "date" and "time". Then I tried to find a common value to merge them but I couldn't manage.

       

      You can find my questions in the attachments.

       

      Thanks in advance!!!