parent/child text File Import
I have a file with a parent child records in the same file.
My game plan is to get it into a table recognize the parents and put them in the parent table and recognize the children and put them in the children table.
The problem I am having is the flat file import chokes on it because the column withs are different from line to line (parent / child).
Any thoughts or suggestions would be apprecaited.
Mardo
parent/child text File Import
SrinivasV
You'll need to import the data into the pipeline as a single wide column and then parse out the required values using a combination of the condistional split component and derived column component.
-Jamie