reading from folder stage

tostay2003 · Post by **tostay2003** » Fri Sep 15, 2006 4:51 pm

Hi,

I have got a folder stage and say i just need to read two specific files i.e. file1.txt and file2.txt out of 100 files in that folder. How can I do that?

Regards

ray.wurlod · Post by **ray.wurlod** » Fri Sep 15, 2006 6:10 pm

Not possible unless you can guarantee that these are the only files in the directory.

Prefer a sequential file stage if the files have the same structure, or two separate data streams otherwise.

kumar_s · Post by **kumar_s** » Fri Sep 15, 2006 6:38 pm

Or filter option, if the file name are in same pattern.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 15, 2006 7:11 pm

Does the Folder stage have a filter option?

kumar_s · Post by **kumar_s** » Fri Sep 15, 2006 7:18 pm

Prefer a sequential file stage if the files have the same structure - Got to see it now.

Ocean · Post by **Ocean** » Wed Dec 06, 2006 1:19 am

ray.wurlod wrote:Does the Folder stage have a filter option? ...

WildCard field in Output Properties page does the filter for source file. Can use File* to filter File1, File2....

chulett · Post by **chulett** » Wed Dec 06, 2006 8:37 am

Technically, 'filters' and 'wildcards' are not equivalent. However, wildcards can be used with more than just the splat - '*'. For example on UNIX:

Code: Select all

file[1-2].txt

Will get you just file1.txt and file2.txt out of the '100 files in that folder'.