Beginner & 
Advanced
Once upon a time, in a faraway land a lovely family lived in a swamp.
One day something unexpected happened…
It was a shock especially for Sherek
Fortunately, was cat in boots 
Cat created the solution for beginner level :
And then …
And Cat in boots also created the solution for advanced level :
And everyone lived happily ever after 
Im not sure if other people wondered. Where is Santa!!! Sure did not read in the challenge where he is…
Must be still “Shopping for Gifts”
He must be going in circles due to the duplicate names in his list… that is why he decided not to land anywhere.
But, as per Advent 4 Challenge, We all know where Santa went. Wink Wink
Here it goes!
Due to Santa Saving up for the Holidays… Santa did not buy a license for a trusty version control system. Because of that… He is currently lost in the air until he finds a solution…
So Santa, called his old friend to fix the problem…
Finally, the Rock has come back to help Santa Claus
Solution for ADVANCE
After a very long speech of the rock making fun of Santa using an excel file to store the names and gifts for the elves. He HURRIEDLY helped Santa to merge the files and find the duplicates
Get it? Hurriedly = Faster hahahaha ;p ;p ;p
So the rock created a data table first, then read both Wishes A and Wishes B.
The rock then merged the output of both Data table A and Data Table B into One.
Upon Merging, he suddenly removed the duplicates then sorted the data table
This gave a quick Victory for the Rock!
Suddenly, Santa called again, but the rock is too tired. So the rock asked his friend to help Santa with his next task
Beginner Solution
The rock then call Maria! He Said, Maria, if you help Santa. I will give you front row tickets to my next movie 
Maria was so delighted she had to close her fist and smile and open her mouth to show her enthusiasm
She then said “Just Bring it!”
So the rock told Maria Sharapova of Santa’s issue and would like to delete the latest file based on creation date.
Maria Sharapova had to think for 1 minute and 03 Seconds
but nothing came out… so she asked for 2 Minutes more hahahaha
Then she realized the solution. So she said! Game on Santa!!
She through the solution right of the Bat!!! I mean Tennis Racket
It was a very hard swing!
So, she said Santa, i will compare both files using files.getcreationtime to solve your problem.
And I’m Going to use Multiple Assign!!! (She said very proudly as if Santa will be impressed)
After that i will be able to get the date and other timestamp parametes in the file… trust me i will
Then she ran the code… Then the output came out
The she told Santa… you trust me now?
And that is the story of how the Rock and Maria was able to help Santa.
by the way…
We managed to find where Santa went.
we saw him somewhere in the UiPath Reboot Work Festival… Must be inside the big tent
Or maybe inside the Souvenir Shop
Looking forward to the next Advent Challenge!
-Sean
Ho ho hoo…Mary Christmas
If you wish to watch my Santa Story the
Episode #1 ==> 
Advent Challenge #1
Episode #2 ==>:Santa: Advent Challenge #2 (Everyone welcome to join the event!) - #36 by Maneesha_de_silva
Episode #3 ==> Advent Challenge #3 - #39 by Maneesha_de_silva
Episode #4 ==> Advent Challenge #4 - #39 by Maneesha_de_silva
Welcome to my Santa Story Episode #5 (Beginner & Advanced Challenge Inside)
Santa Suddenly heard that lady was crying… Santa was wondering who is she … sounds like very familiar who may be … 
Is that @Luiza 
Santa ran to the next room and opened the door
OMG… Its Jingle-Bell…
Santa: oh my lady what happened? why are you crying? , have you seen any ghost ( My Episode #4 )
Jingle-Bell: No… eh eh eh…
Santa: So why are you crying then?
Jingle-Bell: I made a terrible mistake eh eh eh…
Again She was crying loud......
Santa: Its ok dear tell me what happened, we need to hurry we are almost late now
Jingle-Bell: your wishes excel … eh eh eh…eh eh eh…
Santa:: Ok ok then… what happens…
Jingle-Bell: wishes excel has been edited by mistake and now there are duplicate and also i cannot find what i have last created eh eh eh…
Jingle-Bell is really upset about it …
Suddenly Santa start laughing …
Jingle-Bell was angry about that
why are u laughing now, you know want you have lost all wishes and now you are laughing
Santa: You know what, don’t worry my dear… Last year I have modified my Sleigh
with few technologies, I can do my most of the thing on my Sleigh Dashboard don’t worry lets go into my Sleigh
Now You Wondering About The Sleigh DASHBOARD Isn’t it
here we go …
Then Santa access his Sleigh Dashboard and made a new file by removing duplicate
File Name: Kids Wishes Secure.xlsx
Advanced Challenge :
Duplicate Remove Configuration Module : Main.xaml (6.4 KB)
Beginners Challenge :
Main.xaml (9.6 KB)
UiPath APP File: GitHub - manee4422/UipathAPP-Challange5
The below Video show you that How Santa’s Sleigh Dashboard will work
Function: Data Rettriving by Unattended Robot and Sending the Information to UiPath APP and Display via UiPath App With some artificials/By the button of commanding Unattended robot running the process to delete the file 
Dear Santa,
So glad to hear that assistant Jingle-Bell got a personal digital coworker that can do the boring job to assembly all the scattered wish lists into one with unique wishes.
Now Jingle-Bell can play paddle with his kids instead.
#Challenge5 #Advanced
Main.xaml (13.0 KB)
Advanced
Santa needs the mess that Jingle-Bell accidentally made. UiPath bots as always are here to help
Excel Manipulation are so easy with UiPath and here is the workflow
We figure out why Jingle-Bell not using source control: he was in love
I am more than happy to help him with 2 different approaches to his problem.
I have posted here a YouTube video about this: https://www.youtube.com/watch?v=0WPCa70HgUE
Beginner AdventChallenge#5
AdvanceChallenge_5.zip (36.1 KB)
