Hi Friends.
I have to load one excel file to Teradata DB.
But there is lots of white space in that file -row as well as in column,so need to remove.
and we dont have time to make macros for that.
so plz tell me better way to do it.
ok thanks .
Need to extract Excel file...
Moderators: chulett, rschirm, roy
Welcome Aboard
Save it as a CSV file or a tab delimited text file. Read it with a sequential file stage and load it to the database. Pass it via a transformer stage and use trim to trim the leading and trailing white spaces. Make sure you specify the columns as varchar.
Save it as a CSV file or a tab delimited text file. Read it with a sequential file stage and load it to the database. Pass it via a transformer stage and use trim to trim the leading and trailing white spaces. Make sure you specify the columns as varchar.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Welcome Aboard :D
How do you plan to read the Excel file through datastage?
You have a ODBC driver for Excel on Unix to read from the Excel file?
If I had to do it, I would convert the Excel file to a csv file first and then go forward from there.
It's much easiers that way
How do you plan to read the Excel file through datastage?
You have a ODBC driver for Excel on Unix to read from the Excel file?
If I had to do it, I would convert the Excel file to a csv file first and then go forward from there.
It's much easiers that way
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Need to extract Excel file...
Make time.swades wrote:and we dont have time to make macros for that.
Why is it there's never time to do it right, but always time to do it again?
It will require the same amount of work no matter which way you do it - DataStage is not a magic bullet.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.