Posted: Fri May 09, 2008 2:21 am
why you are getting NULL, because the output link consider the date input as string and while writing it is trying to convert to DATE, fails to convert and NULL was passed to output.
Can you check whether any ^M character in the EOR and check whether length and display are given correctly.
still if you get the NULL, the place a transformer before sort. use iconv to convert the date into number, place sort stage, sort it, and then place a transformer. use oconv to convert to date format and then write it in the file
Can you check whether any ^M character in the EOR and check whether length and display are given correctly.
still if you get the NULL, the place a transformer before sort. use iconv to convert the date into number, place sort stage, sort it, and then place a transformer. use oconv to convert to date format and then write it in the file