๐Ÿ™‹โ€โ™€๏ธ ๐Ÿ™‹โ€โ™‚๏ธ Beginners Learning Challenge #4 in the UiPath Forum Community!

Dear Community ,

Are you ready for Beginners Learning Challenge #4: Excel application ? Letโ€™s enhance your UiPath skills further :rocket: with the help of our @pathrudu , @AutomationX_by_Kiran and @loredana_ifrim .

:point_down: Here is the Challenge #4 we have in store for you :confetti_ball: :point_down:

Challenge_4_input.xlsx (10.8 KB)

Take an Excel File, Where it has 3 sheets. First sheet has 4 columns (F.Name, L.Name, DOB, Address) of information and Second sheet has 3 columns (F.Name, Salary, PF) information

Merged the information into a third sheet with 6 columns. PFA sample sheet. Make sure you are using Excel as a Database approach.

:date: Event Date: Today onwards!

:timer_clock: Deadline : Quiz submissions must be submitted no later than the 2024-04-04T20:59:00Z, your time-zone!

Scoring System

  • All submissions earn one star :star2: for participation, regardless of correctness.
  • Correct solutions/Quiz answers receive 5 stars :star2:.
  • The most creative/best practice solution earns an additional maximum 5 stars :star2:.

Feel free to dive into our Beginners Learning Challenge #4 above :point_up_2: and begin sharing your creative submissions.

Thank you and good luck,

UiPath Community

:loudspeaker: Feel free to download the banner and invite your network to join the challenge.

5 Likes

All the best๐Ÿ‘for challenge 4.
Kudos to the team @pradeep_ch , @pathrudu , @AutomationX_by_Kiran , @loredana_ifrim :heart:

4 Likes

Some fun

ExcelAsDB.zip (12.4 KB)

cheers

4 Likes

Hi @pradeep_ch ,

Certainly a good Challenge.!

Attaching My Solution ,
ExcelAsDbChallenge4.zip (21.0 KB)

Happy Automating.!!

@pathrudu , @AutomationX_by_Kiran , @loredana_ifrim

Thanks,
Gautham.

3 Likes

PFB attached file
ChallangeExcelAsDB.zip (12.4 KB)

2 Likes

hi,
May i know the reason why you are connecting to the database.
Thanks

3 Likes

Hello @Maheswar_Reddy ,

Problem Statement :
Take an Excel File, Where it has 3 sheets. First sheet has 4 columns (F.Name, L.Name, DOB, Address) of information and Second sheet has 3 columns (F.Name, Salary, PF) information

Merged the information into a third sheet with 6 columns. PFA sample sheet. Make sure you are using Excel as a Database approach.

It was asked that we need to consider the excel file as a db. Hence in my solution I am connecting to the excel file just like we connect to our db by using Connection String and Provider Name.

Hope I clarified your doubt.

Happy Automating.!

Thanks,
Gautham.

3 Likes

Thank you @pradeep_ch, @pathrudu, @AutomationX_by_Kiran and @loredana_ifrim for presenting the challenge; it provided a fantastic opportunity to explore various options available for reaching the solution.

Attaching solution below for Review:
Challenge4_MergeExcelData.zip (30.6 KB)

3 Likes

Thank you for the Challenge @pradeep_ch,that was something new and challenging ExcelDB_Challenge4.zip (170.8 KB)
cheers

3 Likes

Hi @pradeep_ch
PFA โ€ฆ
Challenge4_UiPath.zip (14.1 KB)

2 Likes

Thank you @pradeep_ch, @AutomationX_by_Kiran, @loredana_ifrim and @pathrudu for the challange
Beginners Challange_4.zip (12.5 KB)

2 Likes

You can do it using excel merge related activities @Maheswar_Reddy

2 Likes

@pradeep_ch @AutomationX_by_Kiran @loredana_ifrim

Thanks for the challenge 4.

Beginners Challenge 4.zip (12.9 KB)

regards
Shiva nikhil.

2 Likes

Hi Team ,

Thanks for the free sessions @pradeep_ch , @pathrudu , @AutomationX_by_Kiran & @loredana_ifrim for the challenges .

Hyperautomation-ai Challenge4.zip (30.6 KB)

Regards
Kumar

2 Likes

Hi Team,

Here the process code for Challenge # 4.
Challenge_4.1.0.1.nupkg (38.3 KB)
Thanks to the team @pradeep_ch , @pathrudu & @AutomationX_by_Kiran

Thanks,
JR

2 Likes

Thank you for the Challenge that was something new and challenging
Challenge4_ExcelAutomation.zip (34.5 KB)

Thank you each and everyone for encouragement and support

2 Likes

Hello @pradeep_ch , @pathrudu, @AutomationX_by_Kiran and @loredana_ifrim
Please find the Solution attached.

Thank you for creating Challenges :grinning:

Happy Automation!!
Excel Automation_UIPATH Challenge 4.zip (16.2 KB)

1 Like

Hi, @pradeep_ch , @pathrudu , @AutomationX_by_Kiran ,

Thanks for the efforts in spreading the knowledge!

Hereโ€™s the solution attached for Challenge 4
Excel Manipulation_Challenge4.zip (13.4 KB)

1 Like

Hi Team,
Thank You for this Challenge 4, this is really a new experience for me to learn.
I really enjoyed doing this challenges.

Challenge4_ExcelAsDataBase.zip (178.7 KB)

1 Like