How to filter multiple columns in excel sheet?

Help Studio
, ,
1

I have 6 columns, to filter those columns, how do filter that column one by one?
first I want to filter the first column, process data present on that column then want to process the next column.

2

@Priyanka_Jadhav1

I guess you can apply all conditions together at same time.

If it is not work for you then try like this.

    OutputDT = InputDT.Select("Column1 = 'Value'").CopyToDataTable

   OutputDT = OutputDT.Select("Column2 = 'Value'").CopyToDataTable

    OutputDT = OutputDT.Select("Column3 = 'Value'").CopyToDataTable

And so on…

3

Screenshot 2021-09-22 140651

4

not working this logic

5

Hi @Priyanka_Jadhav1

As @lakshman suggested Column Name is the Excel column name which you need to Filter

InputDt.Select(“[yourColumnname] =‘FilterValue’”).CopyToDatatable

Regards

6

Hi @Priyanka_Jadhav1

Can you share the Excel file?

  1. Use Read Range Activity - Read the Corresponding excel file.
  2. Use Filter dataTable activity - What column you want to filter
    image
    image646×563 14.4 KB
  3. Do your requirement process
  4. Use write range activity - write the values in the Excel file.
    image

Note: Do it for all columns One by One
Regards
Gokul

7

I used this same logic in my process
but I want to filter multiple columns.

8

i want to filtered multiple columns one by one with same value.

9

Can you share the excel file and more about the Filter process?

Can you share the screenshot of the workflow? @Priyanka_Jadhav1

11

Input.xlsx (17.0 KB)

12

Can you share the screenshot of the workflow? What column to be Filter in the excel?
@Priyanka_Jadhav1

Regards
Gokul

13

Screenshot 2021-09-22 145231

14

Screenshot 2021-09-22 145331

15

if I run the file then output DT is Blank.

16

Screenshot 2021-09-22 150704
Screenshot 2021-09-22 150704367×513 11.3 KB

17

Screenshot 2021-09-22 150611
Screenshot 2021-09-22 150611813×219 4.19 KB

18

how to filter remaining rows in DT?

19

Hi @Priyanka_Jadhav1

Can you share the Excepted Output Screenshot?

Regards

20

Hi @Priyanka_Jadhav1

You can try with below work flow and Excel file
Dummy.xaml (7.6 KB)

Input (2).xlsx (17.6 KB)

  • Filter DataTable must “Contains” → x

image

Hope it will work
Regards
Gokul

21

Screenshot 2021-09-22 154734
Input DT