Page 1 of 1

filter stage

Posted: Tue Oct 04, 2005 10:18 pm
by arvind
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

Posted: Tue Oct 04, 2005 11:27 pm
by ray.wurlod
Use a Switch stage.

Posted: Wed Oct 05, 2005 6:43 am
by kumar_s
HI,
Can also use parameter to pass through......

regards
kumar

Posted: Wed Oct 05, 2005 4:37 pm
by ray.wurlod
How? :?
REGION changes value in different rows of the data set. Job parameter values can not be changed once the job is running.