Partially duplicate names within DataTable causing issues

Help
1

Hi everyone

I’m currently attempting to complete the http://rpachallenge.com/
I’m extremely close to completing it but have come across a snag.

When running the task I’ve found that it manages to input the first name into the correct field but stalls on last name. It took me a while to figure out but I’ve found that it’s due to “name” being both in the “First Name” and “Last Name” field, so it must be recognizing it as a duplicate.

My TypeInto looks like “row(“First Name”).ToString” etc etc

Is there a way for me to get around this without having to change the headers in my CSV?

Thanks

1 Like
2

Can you upload the workflow? thanks :slight_smile:

2 Likes
3

RPAChallenge.zip (3.8 KB)

Hi @Jan_Brian_Despi

If you remove the Last name TypeInto the whole thing works

1 Like
4

I already got the solution:
The Column name 'Last Name ’ has a trailing space. :slight_smile:
So 'Last Name ’ is different than ‘Last Name’

Hope this helps. Thanks.
Despi

3 Likes
5

:man_facepalming: :rofl:

Thank you @Jan_Brian_Despi

1 Like
6

No problem. I got your back :slight_smile:

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.