This flat file needs to be modified to remove extra 2 lines that are not expected. RRS feed

  • Question

  • The current definition being parsed is ****** The stream offset where the error occured is 1141. The line number where the error occured is 20. The column where the error occured is 0.  flat file transation schema needs to be modified to expecting more lines that 4 lines. Needs to remove 2lines
    Friday, October 18, 2019 1:02 PM


All replies

  • So, what is the issue?  Modify your schema so that it matches the file.  If you don't want the contents of those extra lines, don't map them.
    Sunday, October 20, 2019 9:00 AM
  • basially I need to modify the schema to not use footer1,2,3,4 instead it needs to expect an unlimted amount of lines. so needs to change footer1,2,3,4 to an unbounded element
    If I drop the sample files contain 4 lines and the ones that contain 6 lines and alsoo add more lines. it should be unbounde ?

    • Edited by Ram_Bolla Monday, October 21, 2019 3:49 PM
    Monday, October 21, 2019 3:26 PM
  • Yes, then you need to mark that as Unbounded.
    • Marked as answer by Ram_Bolla Tuesday, October 22, 2019 7:32 AM
    Monday, October 21, 2019 9:59 PM