Content Conversion in receiver channel
I have proxy to File scenario, I am receiving data in PI7.1 using proxy communication, and creating a CSV file at FTP location. There is no message mapping involved and there are 50 columns in my input data type, I have kept all the columns as optional.
When I receive the data from proxy, in first row I receive all the header names, so in first row, I receive all 50 column values. Suppose in second row, the value does not exist in ECC table for 5th column, so I receive only 49 column values in my 2nd row ( I donu2019t receive receive start and end tag with empty value for fifth column).
Thatu2019s why in my ouput csv, all the data values after 6th column onwards shifts to left by one place, as there is no value present for 5th column even not an empty value.
Please help me on this how can PI insert that empty value where it finds a missing column.