how to filter in excel dynamic table so that it does not come out # N / A WITH UIPATH and write it in another excel
we can use a select method likethis
–use a read range activity and get the output with a variable of type datatable named dt
–now use a assign activity like tthis
dt = dt.Select(“[yourcolumnname] <> ‘#N/A’”).CopyToDatatable()
–then we can use write range activity and mention the input as dt
does not work I get error “Assign: Cannot perform ‘<>’ operation on System.Int32 and System.String.” I tried to fix it “filterDT = yourDT.Select (” Convert (EPIGRAPH TM1, System.String) = ‘# N / A’ “). CopyToDataTable ()” didn’t work either.
I wait for news, thank you very much and greetings