Exception based on criteria..excel

Help
1

Guys…I have a file that contains roll n Amount…I want to just pull information for data were the value is greater than zero…for anything those is zero i should ignore that and move to next row…
image
please advise.

2

@ShreyaSharma

Please follow below steps:

  1. Read the range
  2. Using Filter datatable activity, filter DM > 0
  3. Write the data table into excel

Please find below the workflow. And you can see the output in “Sheet2” of “Input.xlsx” file

FilteringInExcel_148558.zip (16.8 KB)

1 Like