How to remove Blank columns from Datatable without knowing the Column index

[Shreya_Rao1 (Shreya Rao)]

Hi,

I need to delete the columns from the Datatable which are blank as shown below, how Can i do that?
Please note: the Dt is dynamic and any columns can be blank

[lakshman (Ganta lakshman)]

@Shreya_Rao1

Have a look below thread.

Read Range - Brings new empty columns (Column1,Column2,Column3....)

My suggestion is with the assumption that any phantom data gets added to a column that starts with “Column”. The order doesn’t matter at all. Basically, I have created an array of the columns that start with “Column”, then run that in the loop to remove them. dt.Columns.Cast(Of DataColumn).Where(Function(c) c.ColumnName.StartsWith("Column") ).ToArray this line of code sets an array with only the columns that starts with “Column”. Alternatively, you can run an IF inside that checks the Starts…

Note: Check whether column name is empty or not. If it is empty then delete it using Remove Data Column activity else not.

[Shreya_Rao1 (Shreya Rao)]

Got the Resolution form here

Remove columns are empty

I have a datatable which contains 180 Colums. Out of which some columns are having null values in all the rows. I want to remove those columns. e.g. dtTemp column1 Column2 Column3 Column4 Column5 001 ABC 5 002 XYZ 6 003 PQR 7 I want to remove Column4 and column5. I am facing this error [image]