How to apply filter on column by using for each row

Help StudioX
,
1

i am trying to filter on excel sheet.in which i have Clint data. eg name, address,age ,email…i want to filter data by name column and then take screen shoot… how can i filter this with each Clint name?

2

I believe,this could be done using filter data table

3

@Hemant_Deshmukh

arr_names=datatablevar.asenumerable.select(function(x) x(“name”).tostring).toarray

you can use for each activity to loop through that array and do what ever steps you need

cheers

4

Hi @Hemant_Deshmukh

Use this Linq Query

(From row In DT
Where row(“Column name”).ToString.Trim = “Name”
Select row).CopyToDataTable

1 Like
5

@Hemant_Deshmukh

Welcome to the community

may I know why do you need a screenshot?

on excel it is not good to take screenshot…instead you can use filter excel activity to do your filters…then use save excel as pdf to save it as pdf and then in pdf activities we have save pdf as image…which can be used in converting pdf to image and save as needed

This way everything is done in a cleaner fashion

cheers

6

Hi @Hemant_Deshmukh

Find the zip folder with the expected output screenshots in the newfolder.
Change the excel path and column name in the filter activity

BlankProcess4.zip (619.8 KB)

image
image874×2032 73.2 KB

Hope it helps!!

1 Like
7

thank you so…much…you gave exact solution. :grinning: :pray: :pray: :pray:

8

@Hemant_Deshmukh
Welcome and If you find solution please mark it as solution that can help for others

9

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