@anjasing - Create a datatable variable called Dtfiltered
DtFiltered = DtOut.Clone ==> Dtout is your datatable created from the “Read Range” activity…
DtFiltered = (From r In Dtout.AsEnumerable
Where r("Status").toString.Contains("FAIL")
Select r).CopyToDataTable
Hope this helps…
I want output to be retrieved in form of sales order number like
0311056152 not in form of datatable
if you could help in this?
lets assume a String list with the sales order numbers are fine:
Use an assign activity
leftSide: listSONumbers | Datatype List(Of String)
right side:
(From d In yourDataTableVar.AsEnumerable
Where d("Status").toString.ToUpper().Contains("FAIL")
Select s = d(YourSalesOrderColNameOrIndex).toString).toList
isn’t it fine
assumed it is an assign activity, all variables and col names are ok and there is no validation message then just try it. Otherwise tell us the validation error message
sometimes some caches hangs
(From d In yourDataTableVar.AsEnumerable
Where d(“Status”).toString.ToUpper().Contains(“FAIL”)
Select s =d( YourSalesOrderColNameOrIndex).toString).toList
this is basically why at I am doing
extracting DT from a webpage and saving it in ExtractDataTable now I want to read sales order number with fail status…
please take note from given correction alternate above
Yes error gone…if you can tell how can I print this?
String.Join(“,”,listSONumbers)
IS there a logic after that to only take unique values of sales order numbers and not repeatitive one?
Thank you sooo much
(From d In yourDataTableVar.AsEnumerable
Where d(“Status”).toString.ToUpper().Contains(“FAIL”)
Select s =d( YourSalesOrderColNameOrIndex).toString).Distinct().toList
Thank you so muchhhh
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.