Problem with txt file

lsnovick · Post by **lsnovick** » Fri Aug 16, 2013 8:25 am

arunkumarmm · Post by **arunkumarmm** » Fri Aug 16, 2013 8:52 am

'|' is your field delimiter and not record delimiter.

prasson_ibm · Post by **prasson_ibm** » Fri Aug 16, 2013 1:40 pm

Is your file coming with null value?
What is the datatype you have given for Date,read it as varchar and transform to date in Transformer.

SURA · Post by **SURA** » Sun Aug 18, 2013 5:31 pm

lsnovick wrote:It stops at the second column (SoldDate)

Change the Data type as VC and handle it in the next TFM would allow you...

chulett · Post by **chulett** » Sun Aug 18, 2013 9:05 pm

... or just fix the field and record delimiters.

v_bhaskar · Post by **v_bhaskar** » Tue Aug 20, 2013 4:27 am

are running this job with RCP or normal

srinivas.nettalam · Post by **srinivas.nettalam** » Tue Aug 20, 2013 6:26 am

'|' is the field delimiter not the record delimiter.Remove the record delimiter property and add field delimiter ='|'

DSXchange