Hi All,
I wanted to filter datatable using switch case activity, what expression should I write in switch.
Can anyone assist me on it.
Regards
Saurav
Pls describe better your use case.
Cheers
Hi @J0ska,
I have xls file from which I have retreived a data using read range activity, now I need to use swtich activity to perfrom several operations from the datatable which I get from read range activity, so to do so what expression should I write in switch expression reference to the output datatable.
Regards
Saurav
1/ Assuming you will user “For Each Row” loop to go through all rows in datatable.
2/ Assuming you will switch based on datatable first column named “switch”.
3/ Assuming the first column is integer type.
Then you could use switch expression
cint(row.item(0))
or
cint(row.item("switch"))
You could change my assumptions 2/ and 3/ according your case.
Cheers
1 Like
Hi @J0ska,
As you suggested, I have tried to use below expression but the process doen’t go inside the switch case activity.
Any suggestion.
row.item(0).tostring
Regrards,
Saurav
“Case” is a constant value. In your case (string type) it must be text without quotes.
1/ first case will fire if row.Item(0) contains case
2/ second case will fire if row.Item(0) contains “case”
Cheers
1 Like
Hi @J0ska,
Understood the point you have mentioned, I have used row.item(“column_name”).tostring and case name as “value of column” which I need as output and it works.
Appreaciate your time.
Cheers.
Regards,
Saurav
Hi @J0ska @Palaniyappan,
I have question, after filtering and getting the data from swtich case, how could I update the data to web applciation, lets assume I have 4 different scenarios, for which the output I got from switch activity as mentioned above and now I need to peform 4 different operations on web application to update the data which I got from switch activity.
How to do? any luck.
Regards,
Saurav
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.