Hi,
So, I’ve made a data table of column size 40 and row size 4.
However, i need to find if only the first 20 columns have empty fields. If it is empty, i want to use write line to output the name of the column in which the item is absent for each row.
How do i get the column name in this situation for a particular column?
Inside For Each Row activity you can get all value using either column name or column index.
If you already know all columns name, use them to get value for each and verify if any value is blank or not.
If you don’t know column name in advance, you must be using column index to check each value. In this case, you can use ‘DataTable.Columns(Index).ColumnName’ to fetch the name of the column at that index.