Omit zeros in an excel table

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

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,

1 Like

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
1 Like

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 ,
image
image prueba.xlsx (10.0 KB)

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.