String.Join(Environment.NewLine,readCol.AsEnumerable().Where(Function(r) r(col.ColumnName).ToString<>“” Or r(col.ColumnName).ToString<>" " Or r(col.ColumnName).ToString isNot Nothing).Select(Function(row) row(col.ColumnName).ToString).ToArray())
I’m using this expression to copy columns data and follow the same loop for each column but when I’m using the above expression getting an error strict option disallows late bindings.
Welcome to the community
Looks like you did not change the type argument in your for loop Properties to System.Data.DataColumn…Can you please change it and check
Thanks for quick response.
I am using Set to clipboard activity to copy column data to string and follow the same loop for other columns. So Should I switch it to assign activity to record the list of data.
You need not switch the activity…you can use as you need…
But I believe you are looking theough dt.Columns in a for loop and your item name is col….in that for loop you have to change the type argument to datacolumn…By default it would be object…
I’m still getting an issue.
So let me know if we can connect anytime ?
I have few more questions
We would recommend breaking it down at least for the analysis purposes
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum
Also we can shorten the empty check
Where(Function (r) Not ( isNothing(r("ColName")) OrElse String.IsNullOrEmpty(r("ColName").toString.Trim)))
Sounds also that the intention and the coding approach is divergent