How find first empty row using Select?

Hello Everyone,

I would like to use select, to find first empty row.
How can I do it?

Is it possible to find first empty cell in specific column?
E.g I would like to find first empty cell in ‘ColumnA’ (it is 20 row) but in next ‘Columnb’ is not empty. I would like to select ‘ColumnA’

HI @aleksandra.plichta5

Can you elaborate your task what are you trying to do after selecting the empty line

Regards
Sudharsan

Hi @Sudharsan_Ka

In ‘ColumnA’ I have specific dates.
I have to find first empty to put there my date.

@aleksandra.plichta5

You can select

Dt.Rows.IndexOf(Dt.AsEnumerable.Where(function(x) IsNothing(x(0)) OrElse String.IsNullOrEmpty(x(0).ToString.Trim))(0))

Thus basically check First column you can change 0 to anothwr column index or column name as needed

Cheers

Hey

check this post

Regards

@aleksandra.plichta5

You can try with Find First/Last Data Row activity in the modern design

To enable it
Go to → Activities Panel → Click on Filter → Select Show Modern.

image

Regards
Sudharsan