Date Format in Parallel job
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 497
- Joined: Sun Dec 17, 2006 11:52 pm
- Location: Kolkata
- Contact:
Date Format in Parallel job
Hi All,
There is a date field in the file with data type defined as date and the value as mm/dd/yyyy. The Sequential file stage is unable to read the file.
There is a option of changing the format from default to the one present in the file , the default format is yyyy-mm-dd. Please help me out , how to read the date field in parallel job.
Thanx in advance.
There is a date field in the file with data type defined as date and the value as mm/dd/yyyy. The Sequential file stage is unable to read the file.
There is a option of changing the format from default to the one present in the file , the default format is yyyy-mm-dd. Please help me out , how to read the date field in parallel job.
Thanx in advance.
-
- Premium Member
- Posts: 497
- Joined: Sun Dec 17, 2006 11:52 pm
- Location: Kolkata
- Contact:
-
- Premium Member
- Posts: 497
- Joined: Sun Dec 17, 2006 11:52 pm
- Location: Kolkata
- Contact:
The data in the file is 02/12/2007 and the data type is Date. The filed delimiter is comma . The error that we are getting is :gbusson wrote:what is the warning message in your log?
Parameter specified but not used in flow: DSProjectMapName
##W TOIX 000000 05:28:08(000) <Sequential_File_1,0> Field "Date" delimiter not seen, at offset: 12
##W TOIX 000154 05:28:08(001) <Sequential_File_1,0> Import warning at record 0.
##W TOIX 000018 05:28:08(002) <Sequential_File_1,0> Import unsuccessful at record 0.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Date Format in Parallel job
I have had a similar delimiter problem when I failed to check my input CSV that I received from a coworker. About halfway through the file, the comma that should have separated the 3rd column from the 4th column (4th being nullable and last column) disappeared.
a,b,c,d <- ok
e,f,g, <- ok
...
w,x,y <- not ok
Nothing was wrong in my code, but the source file was created manually from multiple sources and errors resulted.
Also, it bears repeating, have you changed your format to
a,b,c,d <- ok
e,f,g, <- ok
...
w,x,y <- not ok
Nothing was wrong in my code, but the source file was created manually from multiple sources and errors resulted.
Also, it bears repeating, have you changed your format to
ray.wurlod wrote: "%mm/%dd/%yyyy" ?
<<<>>>
My opinions are just that.
My opinions are just that.
-
- Premium Member
- Posts: 497
- Joined: Sun Dec 17, 2006 11:52 pm
- Location: Kolkata
- Contact:
-
- Premium Member
- Posts: 497
- Joined: Sun Dec 17, 2006 11:52 pm
- Location: Kolkata
- Contact:
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Premium Member
- Posts: 497
- Joined: Sun Dec 17, 2006 11:52 pm
- Location: Kolkata
- Contact: