Getting Workflow exception in UI Path Studio

Hi,

I am getting below Workflow exception-

Message:Cannot find column [Threshold]
Exception Type: Evaluate exception.
I am New to UI Path. Please suggest.
image

Thanks

Hi @Anto125,

its not able to find the column name in the datatable, can you verify the column name is correct.
To get the value ->>row("Threshold")

Regards,
Arivu

Can you please tell me when this exception occurred and whats your requirement.

As per my understanding you have used assign activity and tried to get the value .

@karthick
Yes I was doing the assign activity. Requirement was to get random numbers from an excel sheet i set Threshold as 5. The excel has a column named Thresold.

@arivu96- I am still getting the exception. Below is the error.

{
“message”: “Assign : Cannot find column [Thresold].”,
“level”: “Error”,
“logType”: “Default”,
“timeStamp”: “10:58:14”,
“processVersion”: “1.0.6620.34210”,
“fileName”: “Main”,
“jobId”: “cb797aa2-7cbe-4af6-aba0-f64a507b23e6”,
“robotName”: “MANAS”
}

Please check
Thanks

@Anto125
can you attach the xaml file for better understanding

@arivu96- It started working now. Thanks a lot for looking this.

Try to print the columnnames and confirm whether column is present or not

You can do it by using for each and iterate the columnnames name

For each (datatable.columns)

@karthick- I have added a For Each loop below Read CSV, but still it is not printing. Do I need to use a messagebox?

Yes you need use log message or message box to know the values.

Try it and let us know

@karthick- Still not priniting. Attached workflow

Hi @Anto125,

use "Avaiable Columns are"+row.ToString() in the log message and check it.

Regards,
Arivu

1 Like

Great! it worked…thanks. Can you explain me why .ToString() is required to use?

Hi @Anto125,

because its return as object in the for loop, so we are converting into string.

way to convert string values
row.ToString() or Convert.ToString(row)

Regards,
Arivu :slight_smile:

1 Like

Put log Message as “Your required String” + row.ToString

1 Like

Thank you Karthik and Arivu! :slight_smile: