Error while Removing empty columns

[ashokkarale]

@devasaiprasad_K,

Try this solution.

How to remove the empty columns

Okay @anjani_priya then use below mentioned LinQ in Assign Activity: dt_Input = dt_Input.DefaultView.ToTable(False, dt_Input.Columns.Cast(Of DataColumn).Select(Function(x) x.ToString).Where(Function(column) dt_Input.AsEnumerable().Any(Function(row) Not String.IsNullOrEmpty(row(column).ToString.Trim)) Andalso Not column.ToString.ToLower.Contains("column")).ToArray) Assign: [image] Input Output screenshot for your reference: [image] Regards, Ajay Mishra

Thanks,
Ashok