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