Error while Removing empty columns

[devasaiprasad_K]

Hi Team,

i am getting below error while trying to remove empty columns in DT, could anyone help on this

[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

[lrtetala (Lakshman Reddy)]

Hi @devasaiprasad_K

Try the below LINQ Expression,

ExtractDataTable.Columns.Cast(Of DataColumn).Select(Function(c) dt.AsEnumerable.All(Function(r) r(c) is Nothing orelse String.IsNullOrEmpty(r(c).ToString)) ).toList()

Replace the where with select function, it will works fine.

Regards

[ppr (Peter Preuss)]

Getting Back a List of Datacols, where all Datacolumn Values are empty we can do

Assign Activity
ColList | List(Of DataColumn) =

ExtractDataTable.Columns.Cast(Of System.Data.DataColumn).Where(Function(c) dt.AsEnumerable.All(Function(r) isNothing(r(c)) OrElse String.IsNullOrEmpty(r(c).ColumnName)) ).toList()

we just used the full Qualified Name

[devasaiprasad_K]

How to fix this error, this LINQ is not related to above one

[ppr (Peter Preuss)]

looks like you are forking wrong.

let us know what is the overall goal. Is it about checking which cols do have all rows empty column value and then remove it from the datatable?

[devasaiprasad_K]

i am working with some data extraction or scraping a data table from a desktop application, i am getting different outputs in unstructured format and hence trying to see the poosible solution if it can be automated or not
DTTypes.xlsx (9.2 KB)
PFA once

[devasaiprasad_K]

this code is working, i could have initiated new thread for the other issue… sorry for confusion.

[ppr (Peter Preuss)]

Ok, so lets clear.

• the task is not about checking any cols
• the task is to merge col D-H into a D col (as similar to your other topic)

[devasaiprasad_K]

@ppr

• the task is not about checking any cols
• the task is to merge col D-H into a D col (as similar to your other topic)

• the task is not about checking any cols - Yes i was able to correct the syntax
• the task is to merge col D-H into a D col (as similar to your other topic) - checking on this

[ppr (Peter Preuss)]

@devasaiprasad_K

this code is working

so lets get closed this topic by
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum

and we will continue the support on the other topic