Getting Workflow exception in UI Path Studio

studio

#1

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


#2

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


#3

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 .


#4

@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


#5

@Anto125
can you attach the xaml file for better understanding


#6

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


#7

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)


#8

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


#9

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

Try it and let us know


#10

@karthick- Still not priniting. Attached workflow


#11

Hi @Anto125,

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

Regards,
Arivu


#12

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


#13

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:


#14

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


#15

Thank you Karthik and Arivu! :slight_smile: