Field delimiter missing for null data
Posted: Tue Oct 16, 2012 8:25 am
Hi,
We have a job which reads data from legacy tables and create a xml file.
Xml payload part is a concatenation of all the input columns with pipeline as field delimiter. Also we are using NullToEmpty() function in transformer stage before xml output stage to convert all the nulls to empty string.
The problem which we are facing is whenever the last two consecutive column values are null, job is skipping the field delimiter.
Please let us know how handle this situation.
Thanks in advance.
We have a job which reads data from legacy tables and create a xml file.
Xml payload part is a concatenation of all the input columns with pipeline as field delimiter. Also we are using NullToEmpty() function in transformer stage before xml output stage to convert all the nulls to empty string.
The problem which we are facing is whenever the last two consecutive column values are null, job is skipping the field delimiter.
Please let us know how handle this situation.
Thanks in advance.