Omit zeros in an excel table

[cristian_urrego]

Hello, I’m all trying to omit the zeros of an excel table example

Incidence
0
0
0
0
3
3
3
4
4
4

try with filter table but filter the table when I create the new table also generates the zeros even if I have the filter try with conditions but I had no further progress I hope you help me thanks

[Gouda_6]

Hi @cristian_urrego,

Please follow below steps
Step1:arfilterdata =data table.select(“[Incidence]=‘0’”)
Step2:check the count of array of datarow (validation)
Step3:dtfilter=arfilterdata.copydatatable()
Step4:write to excel

Thanks,

[sivapradeep (siva)]

Hi @cristian_urrego

Other Way
Try the Following steps:

1. Read Excel
2. Use For each row
3. Inside for each add if condition
   if(cint(row(“yourColumnname”).tostring.trim)<>0
   print the value using (row(“yourColumnname”).tostring.trim
   E.g: (cint(row(“Incidence”).tostring.trim)<>0
   print row(“Incidence”).tostring.trim
   Thanks

[cristian_urrego]

Thanks for your answer I tried it and it works omits the zeros when I use it with ecribir line I was trying to have it in the excel but it does not omit the zeros

I appreciate you if you help me ,

prueba.xlsx (10.0 KB)

[sivapradeep (siva)]

Hi @cristian_urrego

IS this something you are trying ?

Please find the attached

Main.xaml (12.3 KB)

I have used the following Folder Structure

Attaching the Final Output Sample
Final_output.xlsx (7.2 KB)

Thanks