3 Replies Latest reply: Jan 26, 2016 5:43 AM by Sunny Talwar RSS

    I have two sample files as below I want to combine these two files while loading.

    Bibhuti Sahoo

      I have two sample files as below

                                                    

      file1 .csv
      Date TimeSalesQtySalesValue
      01-01-15 0:5826126100
      01-01-15 7:3010910965
      01-01-15 9:348564
      01-01-15 9:37112453
      01-01-15 9:3923342

       

      file2
      Agent.IDQueue.Time.Secs.HoldTime
      4024730
      40241530
      4016630
      401144
      4031030

       

       

      I want to combine these two files while loading such as final file will be

      Date TimeSalesQtySalesValueAgent.IDQueue.Time.Secs.HoldTime
      01-01-15 0:58261261004024730
      01-01-15 7:301091096540241530
      01-01-15 9:3485644016630
      01-01-15 9:37112453401144
      01-01-15 9:39233424031030


                                                                                                                                                                                 

      What will be the Query??

      Thanks,

       

      Bibhuti