I am reading 4 datasets, combining them through funnel and doing some datamanipulations using a transformer and then output the values in the output file(fixed width file)
My problem is that
From the input file the number of records are coming. But except the first column value others are not coming. it is being set as null..what could be the reason.
Actually i could see the file while open it with textpad with all the contents..i think the null is creating the problem..
I have char as the target field types as it is a fixed width..I am using APT_PADCHAR and set it to ox20..but i think the padding is not happening properly..what can i do to pad it with spaces..
The PADCHAR does not affect the reading of CHAR fields. If you do a "view data" in the Designer of your source file, what is displayed as the value of the second field and what is the correct contents according to your text editor?