Reading of Multiple files using Sequential File stage

[ramu1]

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

[ray.wurlod]

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).

[chulett]

No rows rather than an error usually means a metadata mismatch issue. Can you open a single file directly?

[GowthamSen]

Hi,

The post might be old, but, I am having the same issue.

No rows rather than an error usually means a metadata mismatch issue. Can you open a single file directly? ...

-- Yes, I am able to open the single file directly by "view data" and then execute the job.

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?

[vinothkumar]

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.

[GowthamSen]

Hi

Thanks for your reply.

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.

The exact file names:

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?

[GowthamSen]

Hi All,

I found the issue. The issue is that. there are some "spaces" in the folder name.

Thanks to all for helping me.

[vinothkumar]

Please mark it as resolved.

[GowthamSen]

Please mark it as resolved.

Sorry Vinoth,

I cannot mark it as Resolved. because I am not the author of this post.

[chulett]

Which is why you really should start your own post, even when you find someone else with "the same issue".

If you really think the older post is relevant to your discussion, link to it.