I got an error that column doesnot exist even I have that column in my input
how to check and solve the error
Check the column name where you are trying to get the value from it. May have some blank space in the source.
I have checked everything but still iam facing issue with the column
Can you provide the screenshot of the column list from your file? So we can find out the solution
What is the activity you are using and is it from a datatable?
If it is datatable try to print all column names and compare it with your column name in a notepad
set a breakpoint at a relevant location, debug and use the immediate panel
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum
type in: YourDataTableVar.Columns and check the column names
Please see that you have pass the exact column name as it is in your file or sheet. Also see you are reading the right sheet in which that column is present. Sometimes the name contains some blank space please check that to.
Hi @anjani_priya
It says about Total Value does not belong
check the excel file and copy the column name don’t write it just do copy and paste for that column
an empty string / null value cannot be parsed into a Double
So handle those values e.g. by filtering out for the summming up or use a default value
this is the data I have, I should add c column but in b column i have a string
if i want to take only c column what should i do
this error is throwing
Anil_G
Jai_Pande
rikulsilva
Muhammad_Anas_Baloch
Pavan_kumar15
jjes
aaguirrearanguren
viswanathan.M
Gayathri_Ramanathan
Arya_Squares