I am trying to read a txt file that I put on a UNIX box. It looks like the following:
VIN|SoldDate|BuildDate|IntvDate|ProblemCode|Service|Delivery|Trans|Engine|ProblemCode|SMT|Overall|BirthYear|Mcell|Qcell|Verbatim
I have these settings:
Final delimiter = end
Record = UNIX
Record Delimiter = |
Quote = none
It stops at the second column (SoldDate)
Is there a setting I am missing?
Problem with txt file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
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.
What is the datatype you have given for Date,read it as varchar and transform to date in Transformer.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Re: Problem with txt file
Change the Data type as VC and handle it in the next TFM would allow you...lsnovick wrote:It stops at the second column (SoldDate)
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore