How to exclude zeros

Help Studio
, ,
1

Good morning i would like to exclude zeros from the Csv file before processing it…please assist
image

2

Hi @pabaleloh

Use the read CSV activity and store that data in a data table variable and then use the filter data table and give the columnname on which you wanted to filter and then mention the value as 0 in the value field and this will help you to filter the data and the output data table won’t contain the rows that consists 0 in it.

Regards

3

Hie @pabaleloh here the approach how you can achieve this
your input change build data table with read range and store as a datatable varible
image
use filter data table and configure it with select remove row pass the column name in = 0
image
image

This image displays a workflow in a programming interface, specifically related to mail message handling and data table filtering, with execution logs shown at the bottom. (Captioned by AI)
This image displays a workflow in a programming interface, specifically related to mail message handling and data table filtering, with execution logs shown at the bottom. (Captioned by AI)1008×644 39.4 KB

hope it will work for you as well.
mark it solution if it resolve your Query
cheers Happy Automation … :grinning:

1 Like
4

@pabaleloh

  1. Read csv and store in dt
  2. Filter dt with column name and value as 0
  3. Write csv with dt as input

Cheers

1 Like