Transformer Stage

[naren6876]

Hi
Is there a way to pass the filename being loaded from a sequential file stage into a transformer stage in order to have the filename included as an output field?

Thanks in advance for your help.

Naren

[bchau]

Is there a way to pass the filename being loaded from a sequential file stage into a transformer stage in order to have the filename included as an output field?

A ghetto way of doing it would be to set a job parameter with the file name and output a column with the filename....you could also input it manually without the parameter.

[kcbland]

Only if you used a job parameter as the filename, then the job parameter is also available in the transformer. Otherwise, unless you are willing to use an reverse-engineered method for retrieving job design information, no.

[naren6876]

How to set a filename as a job parameter?
please explain me

thanks,
naren

Only if you used a job parameter as the filename, then the job parameter is also available in the transformer. Otherwise, unless you are willing to use an reverse-engineered method for retrieving job design information, no.

[kcbland]

Add the filename as a job parameter, for example. FRED. At runtime, supply FRED a value using the smart job control you are working on. In the Sequential stage under the filename, use FRED like this:

Code: Select all

/path/path/path/#FRED#.dat

or you can have the path already in the parameter value so just:

Code: Select all

#FRED#.dat

or you can even have the extension in the parameter value so just:

Code: Select all

#FRED#

In the transformer stage, you can just use FRED literally in the column derivation.

[Sainath.Srinivasan]

You can achieve this using FOLDER stage attached to your file. One of the property of the Folder is to return the filename it is currently operating on.

[naren6876]

hi

[naren6876]

Thanks Ken.It works fine for me.
I have a folder which contains filenames.
Now i want to pass this Filenames at runtime.How can i implement this?

Any clues pls

Naren

Add the filename as a job parameter, for example. FRED. At runtime, supply FRED a value using the smart job control you are working on. In the Sequential stage under the filename, use FRED like this:

Code: Select all

/path/path/path/#FRED#.dat

or you can have the path already in the parameter value so just:

Code: Select all

#FRED#.dat

or you can even have the extension in the parameter value so just:

Code: Select all

#FRED#

In the transformer stage, you can just use FRED literally in the column derivation.

[roy]

Hi,
I generally prefer a basic routine to gain list of files from a directory,
for 2 reasons:
1. folder stage should not be used if the diretory contains directories.
2. folder stage might fail with large files (varies per configuration, usually over 100MB or so).

a search in this forum should get you the basic code you need to do the job.

IHTH,