1 Reply Latest reply on Oct 22, 2018 11:58 PM by Ankit Bansal

    Merge data sources

    Skaiste Papuskaite

      Hello everyone,

       

      I have a problem with different data sources - do not know how to merge it.

      One data source - excel file, another - SQL server (SQL data changed into excel file for this example, please find samples attached).

      Both data sources have the same data: CustomerID, Registration date and First order date (which can be NULL). I need to get data like that:

      Excel file:

      CustomerIDRegistration_dateFirst_order_date
      A12018-02-032018-06-03
      A22018-02-042018-08-05
      A32018-02-052018-07-15
      A42018-02-062018-10-01

       

      SQL data:

      CustomerIDRegistration_dateFirst_order_date
      A12018-02-032018-06-03
      B12018-03-052018-08-05
      B22018-03-062018-07-15
      B32018-03-072018-10-01
      B42018-03-082018-06-10

       

      Need to have:  

      CustomerIDRegistration_dateFirst_order_date
      A12018-02-032018-06-03
      A22018-02-042018-08-05
      A32018-02-052018-07-15
      A42018-02-062018-10-01
      A12018-02-032018-06-03
      B12018-03-052018-08-05
      B22018-03-062018-07-15
      B32018-03-072018-10-01
      B42018-03-082018-06-10

       

      What should I do? Can I make union between excel and SQL data somehow?

      Thank you in advance!