filter stage

arvind · Post by **arvind** » Tue Oct 04, 2005 10:18 pm

Hi All,

How can I give a dynamic condition in the filter stage.
I need to generate a file based on the source column value.
eg
Column name is REGION
Values of REGION:
AAA
BBB
CCC
DDD
I need to create a file for each new value of the column REGION.

Please suggest me what to write in the where clause.

Thanks in Advance
Arvind

ray.wurlod · Post by **ray.wurlod** » Tue Oct 04, 2005 11:27 pm

Use a Switch stage.

kumar_s · Post by **kumar_s** » Wed Oct 05, 2005 6:43 am

HI,
Can also use parameter to pass through......

regards
kumar

ray.wurlod · Post by **ray.wurlod** » Wed Oct 05, 2005 4:37 pm

How?

REGION changes value in different rows of the data set. Job parameter values can not be changed once the job is running.