I had datatable with one column name “ID” , it has 100 rows. i need to store these 100 values in one array! is that possible?
Checkout this expression
If you dont want duplicatie
dt.DefaultView.ToTable(true, "ID").AsEnumerable().Select(Function (a) a(0).ToString).ToArray()
If You want duplicate
dt.DefaultView.ToTable(False, "ID").AsEnumerable().Select(Function (a) a(0).ToString).ToArray()
Regards
Sudharsan
How about this expression?
stringArr = dataTable.Rows(0).ItemArray.Select(Function (x) x.ToString().Trim).ToArray()
Regards
Gokul
@MitheshBolla
Please use an assign activity, create an array variable then
dt.AsEnumerable.Select(function(x) x(“Column1”).Tostring).ToArray
can i have this in C#?
Checkout this expresion use in invoke code
here are parameters
Without Duplicate
Str1 =Dt.AsEnumerable().Select(r => r.Field<string>("ID")).ToArray();
Str1= Str1.Distinct().ToArray();
With Duplicate
Str1 =Dt.AsEnumerable().Select(r => r.Field<string>("ID")).ToArray();
To print the array in message box use this expression
String.join(",",ArrCol)
Hope this Helps!
Regards
Sudharsan
If your query got resolved can you mark the appropriate post as solution so that it will be helpful to others with the same query
Happy Autoamation!!
Regards
Sudharsan
Hi , thanks it worked, i tested now
Can you share the screenshot of arguments?
Hi @MitheshBolla ,
I believe your project is already in c#, So you could use the code directly in an Assign Activity instead of using Invoke Code Activity.
Try using the code suggested by @Sudharsan_Ka directly in Assign Activity and let us know what error messages occur.
Invoke code: Exception has been thrown by the target of an invocation.
Invoke code: Exception has been thrown by the target of an invocation.
What is the data type of AllLegalMatterIds variable ? It should be a Datatable.
yes , it is datatable
Still getting same error, all arguments are also correct!