Data Updatation With Logic

Hi…

Total Hrs based on input data Output fill in Status, if value (Total Hrs) is present greater 1 mins write in Done (Status Columns). if no data Output Write in Not Done (Staus columns)… All Other empty Cell fills 00.00.

Input Data:

image

Expected Output:

image

Thanks
Shyam

Hello @Shyam_Pragash ,

You can either use Filter Datatable to filter the rows with null value or you can use the below linq query(in the doc). Then you can get only the Asst.Name which are null. Then loop through that values and filter the main Datatable using the Asst.Name which we already extracted and update the value of Status,OnTime,Out Time and Total hrs using Update Row Item activity.

try this @Shyam_Pragash
Mainimg (2).xaml (16.3 KB)

logic - loop over table

  • if String.IsNullOrEmpty(CurrentRow(“Total Hrs”).ToString) then set blanks = 00.00.00, status = not done
  • if total hrs > 1 minute , status = done

Hi @jack.chan

i have bulk excel data more 500 rows and columns… i mentioned few data only…

can you tell me linq methods… its helpful for me…

Thanks
Shyam

Hi…

i will try to find greater than or equal to 1… but i got error… “Assign: String was not recognized as a valid DateTime.

If((Math.Abs(Convert.ToDateTime(CurrentRow("Total working hrs").ToString).Minute)>1),"In","Out")

how to fix this issue…

Thanks
Shyam