Reading of Multiple files using Sequential File stage
Moderators: chulett, rschirm, roy
Reading of Multiple files using Sequential File stage
Hi Friends,
I am having two similar files in source with same metadata , FileNames like product1.txt,product2.txt.
I am trying to read two files with Readmethod= FilePattern ,Mechanism in SeqFile Stage, with file name like product*.txt, and also tried like product?.txt.
But Now rows were returned while i am trying to view the data.
Please help me in this issue as soon as possible.
Thanks&Regards
Ramu
I am having two similar files in source with same metadata , FileNames like product1.txt,product2.txt.
I am trying to read two files with Readmethod= FilePattern ,Mechanism in SeqFile Stage, with file name like product*.txt, and also tried like product?.txt.
But Now rows were returned while i am trying to view the data.
Please help me in this issue as soon as possible.
Thanks&Regards
Ramu
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
We don't do "urgent". DSXchange is an all-volunteer site whose members post as and when they can. Being asked for urgent response is, frankly, offensive.
If you want urgent help, sign up with your official support provider for priority service, and learn just how much "urgent" costs.
What you have done looks alright, provided that the File Pattern property contains the full pathname of the files you want to read (including wildcard characters in the basename portion of the pathname).
If you want urgent help, sign up with your official support provider for priority service, and learn just how much "urgent" costs.
What you have done looks alright, provided that the File Pattern property contains the full pathname of the files you want to read (including wildcard characters in the basename portion of the pathname).
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.
-
- Participant
- Posts: 21
- Joined: Tue Nov 02, 2010 2:36 pm
- Location: India
Hi,
The post might be old, but, I am having the same issue.
I have 2 files, and I am trying to read those 2 files using sequential file stage using File Pattern. But the job fails showing the error as "Couldn't find any files on host 01WE9UWIN2003 with pattern D:/Common/Team Data/training/DS Data/Files_Pattern/EMP1.txt."
Am I missing anything there?
The post might be old, but, I am having the same issue.
-- Yes, I am able to open the single file directly by "view data" and then execute the job.chulett wrote:No rows rather than an error usually means a metadata mismatch issue. Can you open a single file directly? ...
I have 2 files, and I am trying to read those 2 files using sequential file stage using File Pattern. But the job fails showing the error as "Couldn't find any files on host 01WE9UWIN2003 with pattern D:/Common/Team Data/training/DS Data/Files_Pattern/EMP1.txt."
Am I missing anything there?
Thank you,
Regards
Gowtham
(Learning DS)
Regards
Gowtham
(Learning DS)
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
-
- Participant
- Posts: 21
- Joined: Tue Nov 02, 2010 2:36 pm
- Location: India
Hi
Thanks for your reply.
File Name1: D:\Files Pattern\EMP1.txt
File Name2: D:\Files Pattern\EMP2.txt
The meta data also same for both.
Any other thing I am missing here?
Thanks for your reply.
The exact file names:vinothkumar wrote:What are your exact file names and how did you gave in Sequential file stage. Also check that the metadata is same for both files and you are able to view both files when read individually.
File Name1: D:\Files Pattern\EMP1.txt
File Name2: D:\Files Pattern\EMP2.txt
The meta data also same for both.
Any other thing I am missing here?
Thank you,
Regards
Gowtham
(Learning DS)
Regards
Gowtham
(Learning DS)
-
- Participant
- Posts: 21
- Joined: Tue Nov 02, 2010 2:36 pm
- Location: India
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
-
- Participant
- Posts: 21
- Joined: Tue Nov 02, 2010 2:36 pm
- Location: India