Hi,
Iam using switch stage. I have a column Year and it has value starting from 1990 to 1999, in switch case properties I mentioned
Case = 1990 =0
Case = 1991
Case =1992=1
Case=1993=1
Case=1994
Case=1995=2
Case=1996=2
Case=1997=2
and in options
I mentioned
Discard Value =2
MY aim is to discard year records 1995,1996 and 1997 to the dataset but my job is failing by throwing the following error
Switch_3,0: Output dataset number 2 has no case values assigned to it.
I have Link label values as 0,1,2 and primary reject and datatype of Year input column is integer.
Thanks,
Somaraju.
Switch Stage
Moderators: chulett, rschirm, roy
Switch Stage
somaraju
Re: Switch Stage
somu_june wrote:Hi,
Iam using switch stage. I have a column Year and it has value starting from 1990 to 1999, in switch case properties I mentioned
Case = 1990 =0
Case = 1991
Case =1992=1
Case=1993=1
Case=1994
Case=1995=2
Case=1996=2
Case=1997=2
and in options
I mentioned
Discard Value =2
MY aim is to discard year records 1995,1996 and 1997 to the dataset but my job is failing by throwing the following error
Switch_3,0: Output dataset number 2 has no case values assigned to it.
I have Link label values as 0,1,2 and primary reject and datatype of Year input column is integer.
Thanks,
Somaraju.
Hi,
In switch stage, we need to give like
Case=1990=0
Case=1991=1
Case=1992=2
Case=1993=3
Case=1994=4
Case=1995=5
Case=1996=6
Case=1997=7
Case=1998=8
Case=1999=9
Input data is diveded into 10 output links.
If you need to load 1995,1996,1998 output links data into single Dataset,you can use Funnel stage collects data from these 3 input links then load data into dataset.
Thanks
srini