Hey guys, I need to filter this MRA.xlsx (9.4 KB) file, with the MSTA column containing only blanks. I tried filter datatable activity, by using IsEmpty option, but the column contains space. So, please let me know how this can be resolved. Thank you.

I tried and got it FilterBlank.zip (9.9 KB) Thanks

Yes, you can write but if the second time writing data is less than already present data it will not over write that… Solution: 1.Use Bigger range like “A1: J100” in the write range then it will work good. Let me know if you achieved it… Cheers. Vashisht.

Hey @Vashisht Can’t we use just “” in the range, because we dunno the range. Thanks

But if we keep empty range it will not overwrite the whole sheet.

So, is there any alternate like using rows.count +1 or anything else ?

@NiranjanKN , If you want to filter excel sheet, I’ll suggest you to use Filter Table activity take Filter Table activity Excel Application Scope and set the workbook path. Set all the parameters like sheetName, ColumnName and table name. as shown in below shot. for the table name, first you have…

If the number of columns is fixed then You can get the range of the data table… 1.Like the column is known and the rows count can be derived by DT.rows.count 2.Then you can give the range as “A”+DT.rows.count.tostring+“ColumnCountAlphabet”+DT.rows.count.tostring Then it will work fine… Cheers. …

Hey, @samir I tried to use this, but didn’t get where to get the table name ? Thanks

[image] samir: for the table name, first you have to create table in excel and pass that table name in activity parameter @NiranjanKN You need to create table in excel, click on any cell in table and press ctrl+t

Hi @NiranjanKN , I have work around solution for this problem. 1.In my workflow just add one activity i.e Balareva Delete sheet activity and mention path of the excel and the sheet name… 2.Then use the write range with blank only it will work fine. 3.The only problem is the excel sheet should con…

Hey, @samir What can be mentioned in the Filter options, if I need to keep only rows which as Hello in the ‘MSTA’ column. Thanks

Filter datatable by blanks

Help

samir (Samir Mohite) November 14, 2019, 11:25am 18

hey @NiranjanKN,

I don’t get what you’re saying, could you please elaborate more.

Filter Blank rows

Topic		Replies	Views
Filter datatable containing blanks and write range data Activities datatable , excel	7	1001	September 24, 2020
Delete datarow Studio studio , question , activities_panel	5	406	March 28, 2023
Filtering only Blank and write the filtered value Activities excel , activities , question	10	2264	September 6, 2021
Filter Data Table and Return blank cells Help robot	19	4291	May 17, 2019
How to pickup blank row by filter activity StudioX studiox , question	7	790	February 22, 2023

Filter datatable by blanks

Related topics