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

    Loading data from 2 files, and merging them?

    Ian Cornish

      Hi,

       

      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:-

       

      [Child]:

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

      from <Filename>;

       

      [tmpParent]:

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

      from <Filename>;

       

      [PArent];

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

      from tmpParent

      LEFT JOIN

      Resident Load [ColD] from Child;

       

       

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