Skip the Write Range if the read range variable is empty

[Priyanshu_Gupta]

Hi can anyone please help in making me aware how can i make sure the data fetched from Datatable using Read range in Excel Application Scope to only enter those fields or rows (using write range ) which are filled and ignore the one’s are empty as i have to copy total 15 rows. And if somehow i only get 5 rows how can i jump to next step after writing only 5 Rows to the Excel.

Thanks

[nrok (NRokos)]

Hi, if you have read data with Read Range and filled the Output, you can working with datatbles, here you can filter table or use loop with if with not null condition for each row.

[Priyanshu_Gupta]

Hi Nrok, thank you for taking out time and giving the suggestion can you please walk me through how can i filter table?

[nrok (NRokos)]

You can filter tables with many ways. The most known is Filter DataTable or with .Select. Please check the following links:

Filter datatable by blanks

hey @NiranjanKN, I’m trying, how to use Not Equal to in filter options of filter table activity. But there’s an alternate option, which is recording a macro in excel and use it by using Invoke VBA activity here’s the Example code, Sub Macro1() ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=5, Criteria1:= _ "<>A2", Operator:=xlAnd End Sub This worked well. but, as you can see I’ve used “<>A2” but while using <> in filter option it’s giving error. So using recording …

How to Filter Data Table

Hi Dear, You can use Activity Filter Data Table [image] [image] Thanks!