Need to load the file name(source) to the table

tsktsk123 · Post by **tsktsk123** » Mon Jan 21, 2008 7:35 am

we have a requirement to load the file name which we use as the source to the table. can anyone help me on this? Do we need to use DS routines for this or is there any other way to do this? appreciate any help on this.

regards,
senthil

ray.wurlod · Post by **ray.wurlod** » Mon Jan 21, 2008 7:42 am

Welcome aboard.

The Sequential File stage has a "File Name Column" property which captures the file name into the named column.

It also has a "Row Number Column" property, which is sometimes useful.

tsktsk123 · Post by **tsktsk123** » Mon Jan 21, 2008 9:31 am

Hi,

Thanks for the quick response, it works well. But only issue it gives the entire path not only the filename, please let me know is there a direct way to get only the file name. We can use the fuctions to extract the file name alone, just want to check if there is any direct way of doing it using the sequential file stage(fileNameColumn) function itself.

regards,
senthil kumar

ray.wurlod wrote:Welcome aboard.

The Sequential File stage has a "File Name Column" property which captures the file name into the named column.

It also has a "Row Number Column" property, which is sometimes use ...

ray.wurlod · Post by **ray.wurlod** » Mon Jan 21, 2008 7:52 pm

There is not.

I take it your intention is to use Field() and Count() functions?