Hi All,
I have to fetch which column has no value and display column name in message box which activity I have to use to achieve this?
you need to first extract the table usign extract table activity then filter with empty value in each column
then you would know the column names
sample flow
cheers
1- Extract Table Using Data Scraping->Assign Output Variable Dt
2- For Each Row In Dt
3- If Currentrow(0).tostring=“” then → Message Box ("Here Print your column name with index 0 ) to print header. Else… “None”
As mentioned above - extract the webtable into a datatable - dtData
is it about simple report, like checking if a column has 0,1 or more empy values?
Assign activity:
arrColWithBlank =
(From c in dtData.Columns(Cast(of DataColumn)
Let chk = dtData.AsEnumerable.Any(Function (x) isNothing(x(c).toString.Trim) OrElse String.IsNullOrEmpty(x(c).toString.Trim ))
Where Not chk
Select cn = c.ColumnName).toArray
then use String.Join(“,” arrColWithBlank) or immediate panel
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum
Or so you need a fetailed report of row index, col index / colname for all columns with blank values?