topic RE: Custom excel fields in Product Forum

Custom excel fields

MuthukumarSinga — Wed, 11 Dec 2019 12:07:00 GMT

Hi All,

I have exported an excel as collection which contains some of the "Custom fields" . When I tried to filter the collection using those custom fields, I get an error stating that the field doesn't exist in the collection whereas I can see it in the collection as like any other fields.

------------------------------
Muthukumar Singaram
RPA Consultant
High Speed 2
Europe/London
------------------------------

RE: Custom excel fields

vivek.kumar.goel — Mon, 16 Dec 2019 03:53:00 GMT

Can you show the headers for that collection/excel?

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
https://www.rpatools.com/
"If you like this post, please press the "Recommend" Button.
------------------------------

RE: Custom excel fields

ManojDhamrala — Mon, 16 Dec 2019 06:53:00 GMT

Hi Muthukumar,

Please check for white spaces in the headers that could be the reason.

------------------------------
Manoj Dhamrala
------------------------------

RE: Custom excel fields

MuthukumarSinga — Mon, 16 Dec 2019 09:52:00 GMT

Thanks Vivek & Manoj. There is a leading and trailing space in the column name. I need to trim it before using it

------------------------------
Muthukumar Singaram
RPA Consultant
High Speed 2
Europe/London
------------------------------