Hi, i have trouble initialising the DataRow array which filters the data table from the extraction of Workitems. I am not sure how to go about doing it.Can someone help?
Check your data table
Check?The datatable is extracted using the data scaping tool
before assigning the value to datarow check the length and assign
Use if condition
if it is true assign the value.
if its false there is no record match in the column value.
Erm, Could you explain further? Do you mean I put the dt.select(“Type=‘WI5’ and Status=‘Open’” in the if condition? Then assign the datarow array after? Before assigning to an output argument?
yes, check in if condition using below condition
dt.select("Type='WI5' and Status='Open'").Length>0
if its true assign the value
WIList=dt.select("Type='WI5' and Status='Open'")
I think your datatable dt_Wls might be null.
Better while creating the variable itself initialise the variable new DataTable
It seems that DataRow is not initialized. please try many times to initialize.
@arivu96 How do we initialize WIList? I am running into a similar issue.
dt populates the output in a csv but WIList doesn’t produce anything.
Here’s a link to my post.