Positional Flat file schema problem

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Positional Flat file schema problem

Viewing 0 reply threads
  • Author
    Posts
    • #24470

      Hi,

      I have created a positional flat file of fixed length with one repeating record.The flat file looks like

      eliment1eliment2eliment3123456 123456 123456 ……… etc

      the record repeats 200 times and it can contain white spaces if record is empty.

      I have mapped this schema with a destination schema where I mapped the repeating record with destination’s repeating record.If the repeating record contains white spaces, it is mapping white spaces to destination schema. I dont want white spaces i.e empty record values to be mapped to destination shema.

      i.e  for below file with one repeating record and trailing white spaces, only one record should be mapped

      and not 200 records(remaining all are white spaces)

      eliment1eliment2eliment3123456                                                   etc.

      Please provide a solution for this.

      I have tried to use value mapping but it is mapping white space if the first parameter is set to false.

      I dont want to map the record if there is are all white spaces in the repeating record.

      Thanks

       

       

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.