Week 4 - Solve Industry Use Cases - Reconciliation of Two Reports

Learning Initatives Reboot Your Skills 2021
62

Hi Ann

Yes, but the calculation.
I have defined in template file.

Thanks

1 Like
63

I have fixed it, done.
Its working now

Thanks!

3 Likes
64

Once you get the process, it worked. I had a few issues with the insert and keeping the filenames straight. I must have click on None when inserting the Vendor ID, it kept erroring out until I changed to the single line.

1 Like
65

Here is a solution which doesn’t require coding. It is not as fancy as Clayton’s and in programming world you would definitely follow mentioned above. But since StudioX is about No-Code, here is how you can also do: UiPath StudioX - Using switch to solve month naming issue (in different language) - YouTube

66

Hi Bianca, can u please share the files or else provide me the link, i am new to Uipath thats why.

67

Hi, I found a way to solve the problem of transfering number into month in English for those who work in other languages. Hope it will help.

  1. Create an excel file naming ‘Correspondance’ (or sth esle) in a file other than ‘Download Files’

  2. List the numbers and the months in English manualy

  3. Use Volookup fonction in UiPath to find the correspondent months (see image)

Sans titre

Got the correct result in the end.

68

That was a tough one, but I got there in the end!