AnsweredAssumed Answered

How can I create a flat file profile (for output) which has "line" data on the same physical line in the flat file as the "header" data?

Question asked by MarkPond7981 on Oct 15, 2014
Latest reply on Oct 17, 2014 by MarkPond7981
I've got parent & child data which I am trying to convert into a flat file. The flat file structure is column-based and needs a structure where the lines data is on the same line of the file as the header data.

For instance, a header record which has 4 line items needs to generate a file with a structure of:
     [header][line][line][line][line] 

     Currently what I have been able to generate is either

          [header][line]
          [header][line]
          [header][line]
          [header][line]

          or 

          [header]
          [line]
          [line]
          [line]
          [line]

          I think using the results of the second profile and then using a data processing shape to strip [\r][\n] might be my best option but wanted to check before implementing it.
           
Thanks,
Mark

Outcomes