Data Updatation With Logic

Help Activities
, , ,
1

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

2

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.

3

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
4

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…

image
image1365×351 36.8 KB

Thanks
Shyam

5

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