2 Replies Latest reply: Jul 18, 2017 6:16 PM by Marco Wedel RSS

    Loading data from 2 files, and merging them?

    Ian Cornish



      I have a series of flat files, of which 2 are particularly troublesome... The Parent table has 99% of the data I want, but some of the rows have child data in Child (ColD).


      The record in Child joins to ColC


      Would this work in theory:-



      Load [ChildA] as [ColC], [ChildB]

      from <Filename>;



      Load [ColA], [ColB], [ColC]

      from <Filename>;



      Resident Load [ColA],[ColB], [ColC]

      from tmpParent


      Resident Load [ColD] from Child;



      (I should add that I'm away from my server for the weekend, and this is seriously bugging me!)