Could you please help me to fix below error?
Below is the error:
kindly check once with the variable datatable passed to the FOR EACH ROW activity whether it has any rows in it or not
to validate that we can use a WRITE LINE ACTIVITY and mention like this
which will give us the count of rows
place this writeline activity before to the for each row loop and check with output panel so that we would come to know the issue
Check this s well
This is regarding Assignment 2- Generate yearly report.
Unable to execute write line activity.
may i know what is the datatable name
@Shah, looking at the PNG it is clear that dt_Workitems is NULL. So any .Rows.Count will fail.
Copy or move the Write Line box to immediately after the place in the code where you expect the dt_WorkItems to receive data (right after the call, look-up or whatever gives you the data).
If it fails there aswell (is NULL/NOTHING) then your call is not returning data. Check the query in the source system and try again.
check your invoke for this activity, check ur extract datatable invoke and check your extract datatable activity.
AND IVE BEEN ASKING FOR THIS FOR I DON’T KNOW HOW LONG