3 Replies Latest reply: Dec 12, 2017 1:38 AM by Shahzad Ahsan RSS

    How to merge two tables in data load editor

    Shahzad Ahsan

      Hi Everyone

      I have 2 table Employee & Document. From two data sources. Employee is in SQL where as Document is in Excel

       

      EmpIdEmp Name
      1A
      2B
      3C

       

      DocumentIdDocument
      1D1
      2D2
      3D4
      4D4

       

      I need result like this

       

      EmpIdDocumentId
      11
      12
      13
      14
      21
      22
      23
      24
      31
      32
      33
      34

       

      Make sure I need it in data load editor only.