FILTER TABLE

I HAVE EXCEL FILTERED WITH TABLE FILTER HOW CAN I WRITE IT IN ANOTHER EXCEL

REGARDS

2 Likes

Hi @Manoli_Puente
You can use Write range activity if you want to write it down the filtered dattable in new excel.

cheers :smiley:

Happy learning :smiley:

1 Like

Use Read Range and save it in variable :------ Datatable1
Use Filter Datatable Activity and Give Input as Datatable1 and assign output variable as OutDatatable
In Filter Datatable activity give column name in which you want to filter ----say if Column name “ID”=5 then keep those data
then in column write column name as “ID” and then operator for condition and value say “5”
then by using write range you can write filtered data into another sheet.

2 Likes

with this activity filter datatable, of an excel with # N / A, how do we put the condition The name of the column “ID” not equal to # N / D?

Thank you

You can use not contain “#N/A”

1 Like

we get it with assing “readExcelBI.Select (” [columnName]> = ‘0’ "). CopyToDatatable

regards

Hi
-in select method we can filter that condition and get the output datatable back
for more details on that

–then use write range activity and mention the datatable variable as input and enable add headers property in the property panel of write range activity

hope this would help you
Cheers @Manoli_Puente

1 Like

exceeded filtered by
leerExcelBI.Select ("[EPÍGRAFE TM1] >= ‘0’"). CopyToDatatable

another question…
If the cell where you have to write varies each month, how to solve it …

greetings and thanks