I’m a real novice, but here it goes :
I have a branch defined in my mapping that checks if an input record contains a certain variable that isnt null. If this field is found, it maps across from the input a single item (the one checked for) and 2 other elements. If it is null, nothing done.
My output flatfile schema has a 22 character line defined for the 3 elements.
Now the mapping loops through the input, checking each record for the value, writing it to the output if exists.
When I check the output file, the first, and only instance of the element being checked for is there, correctly filling the 22 characters. Yet as i check further down the output I notice that where ever the line should have been, but wasnt due to it not existing in the input, there is now a 22 character blank field. Is there any way to supress this line being printed if the value is null?