How can I get the column name that has empty rows?

[KiterCodes (Kiter)]

I’m trying to make an automation to find which rows are empty and what column do they belong. Is that possible ? Imagine , that I have 3 columns in these 3 columns I want to know which are the rows that are empty and return the column name of those rows.

[Yoichi]

Hi,

Hope the following helps you.

dt.Columns.Cast(Of DataColumn).Where(Function(c) dt.AsEnumerable.Any(Function(r) String.IsNullOrEmpty(r(c).ToString))).Select(Function(c) c.ColumnName).ToArray

Main.xaml (8.2 KB)

Regards,

[KiterCodes (Kiter)]

@Yoichi No luck here , that script simply tells me what columns has an empty row and I don’t want that. Imagine , if I take an empty row from a datatable I want to know where does that row belongs. Here’s what I did so far , I read my excel file and I did a for each row then I tried to put the column name hardcoded like this row(“ColumnName”).ToString , it works but I wanted to work dynamically.

[Yoichi]

Hi,

Alright. Is the following what you mean?

Sample20210706-1.zip (8.9 KB)

Regards,

[KiterCodes (Kiter)]

You’re a god @Yoichi . Thank you very much for your help.