Hi All,
I am facing problems while reading excel file in Datastage Px in Unix environment.
I have tried doing it using sequential file stage, but it is not able to read the data.
If am I converting it into csv file (manually) then I am able to do read it.
But we will be getting pleanty of such source files. So can not do it manually.
My questions are ---
1. Can we read Excel files in Datastage on Unix platform?
2. If no, then how to convert excel files into Csv format in Datastage.
Can anyone help me...
Regards
Anand
How to read excel file in Datastage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 36
- Joined: Wed Dec 27, 2006 3:50 am
- Location: Phoenix
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Doesn't the DSXchange Search facility work for you?
This question has been asked, and answered, on more than a few occasions.
This question has been asked, and answered, on more than a few occasions.
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.