How to filter datatable using switch case activity

Build IT Automation
#1

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

#2

Pls describe better your use case.

Cheers

#3

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

#4

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
#5

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

#6

“Case” is a constant value. In your case (string type) it must be text without quotes.

image
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
#7

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

#8

:+1:

#9

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

#10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.