How to filter the based on cell in excel


#1

In this excel sheet except “account” i need to get all the values.
i need to filter based on the " account"


#2

Use read range on excel and output is datatable.Then
datarow[]=Outputdatable.select("dept <> ‘account’ ")

@sureshselvamani


#3

@sreekanth
Outputdatable.select("[dept]= ‘account’ ")
in the above statement can i give array variable which contains different values instead of “account”. how can i give it.


#4

list.xaml (8.2 KB)

@Manjuts90


#5

@sureshselvamani
I am attaching a workflow that

  1. Reads excel into data table
  2. Select the required rows from the datatable.
  3. Copy the required rows in another datatable.
  4. Output the new datatable.

Please let me know if you have any queries.

list.zip (7.8 KB)