How to use the switch stage

[meet_deb85]

Can someone plz suggest me how do i utilize a switch stage......

I am not getting any clue regarding what i need to declare in the case field

when i am using usetr defined mapping.............

[AmeyJoshi14]

Hi ,

Case statement in switch is used to pass the value of the column.
In our project we are using switch stage to get output from column name mentioned in the source.
In the property tab there are following option:
Input:
Selector="Select the column_name"
eg:my column_name is TABLE_NAME
User-defined mapping:
Case="Value of teh input column_name to be passed "
eg:my coulmn TABLE_NAME has values like CUST_DETAILS,AGENT_DETAILS ans so on...
Option:
If Not Found=Depending upon your requirement.
Now in the case statement if select CUST_DETAILS, my column TABLE_NAME will have only CUST_DETAILS, no other values.

[ray.wurlod]

For each source column value that you specify you also need to specify to which output link that row will go. Output links are numbered beginning from zero.