⭐ Level up your automation beginner journey: #3 Beginner Challenge awaits you! 🏆

[loredana_ifrim]

Dear Community,

Hope you enjoyed and exercised your UiPath automation skills with our #2 Beginner Challenge:

Level up your automation beginner journey: #2 Beginner Challenge awaits you!

Dear Community, Hope you enjoyed and exercised your UiPath automation skills with our #1 Beginner Challenge: Here is the Challenge #2 we have in store for you crafted together with @pradeep_ch , @AutomationX_by_Kiran and @pathrudu How can you create an automation that creates a list for storing names and displays it. Event Date: Today onwards! Deadline : your submission must be submitted by the 2024-04-24T20:59:00Z (UTC), your time-zone! Stay tu…

Here is the Challenge #3 we have in store for you crafted together with @pradeep_ch , @AutomationX_by_Kiran and @pathrudu

How can you create an automation process of reading a CSV file and displaying its content in the output panel.

Event Date: Today onwards!

Deadline : your submission must be submitted by the 2024-04-28T20:59:00Z, your time-zone!

Thank you and good luck,

UiPath Community

[Gautham_Pattabiraman]

Hi @loredana_ifrim ,

Thank you for presenting the last challenge of the series.

@AutomationX_by_Kiran ,@pathrudu and @pradeep_ch Thank you for creating the last challenge of the series.

Adding my Submission
Challenge3_CSV.zip (4.0 KB)
Awaiting the results on 29th …!

Best wishes to everyone.!

Thanks,
Gautham

[Aditi_Indoriya]

Hi @loredana_ifrim ,

Thank you for Organizing the challenge#3.

@AutomationX_by_Kiran ,@pathrudu and @pradeep_ch Thank you for creating challenge of the series.

Please find attached solution below:

Level Up Challenge 3.zip (3.6 KB)

Best wishes to all participants!

Best Regards,
Aditi Indoriya

[lrtetala (Lakshman Reddy)]

Hi @loredana_ifrim

Thanks for presenting the challenge @pradeep_ch , @pathrudu and @AutomationX_by_Kiran

Here is my submission

Challenge3.zip (45.8 KB)

Regards,
Lakshman Reddy

[Parvathy (PS Parvathy)]

Hi @loredana_ifrim , @pradeep_ch , @AutomationX_by_Kiran and @pathrudu

Thank you for presenting Challenge #3! Herewith, I’m attaching the attached workflow zip file.

Input CSV Data:

Output:

Automation Beginner Journey Challenge 3.zip (48.0 KB)

Regards
PS Parvathy

[tazunnisa.badavide (Taj)]

@lrtetala

Hi @loredana_ifrim

Thanks for presenting the challenge @pradeep_ch , @pathrudu and @AutomationX_by_Kiran

Here is my submission

Hi @loredana_ifrim

Thanks for presenting the challenge @pradeep_ch , @pathrudu and @AutomationX_by_Kiran

Here is my submission
Challenge3.zip (50.6 KB)

[ashokkarale]

Hi @loredana_ifrim , @pradeep_ch , @AutomationX_by_Kiran and @pathrudu

Thank you for one more challenge. Here is my submission.

Solution:

Output:

Code:
CSV Operation.zip (3.5 KB)

Thanks,
Ashok

[chandreshsinh.jadeja]

A big thank you to @AutomationX_by_Kiran, @pathrudu @loredana_ifrim , and @pradeep_ch for the series! Submitted my challenge 3 task.
Challenge 3.zip (3.3 KB)

Happy Automation!!

[treesa.maria]

Hi @pradeep_ch, @AutomationX_by_Kiran, @pathrudu

Thank you for conducting this challenge.

Please find the attached solution

Challenge3_CSV_Operations.zip (4.3 KB)

Best wishes everyone

[anjalidahiya]

Hi Team,

I’m excited to submit my solution for the challenge #3. Please find attached my completed work.

Thank you @pradeep_ch @loredana_ifrim @pathrudu @AutomationX_by_Kiran and team for the opportunity to participate in this challenge. I look forward to your feedback.

Best regards,
Anjali Dahiya

DisplayCSVData_Challenge3 - Anjali Dahiya.zip (55.0 KB)

[DevendraRPA (Devendra Singh)]

Dear Team,

I hope this message finds you well. I’m excited to submit my solution for the challenge #3. Please find attached my completed work.

Thank you @pradeep_ch @loredana_ifrim @pathrudu @AutomationX_by_Kiran and team for the opportunity to participate in this challenge. I look forward to your feedback.

Best regards,
Devendra Singh

DisplayContent_Challenge3 - Devendra Singh.zip (5.2 KB)

[chethan.dinnupati (Chethan Kumar DS)]

Hi @loredana_ifrim,

Thanks for the opportunity @AutomationX_by_Kiran , @pathrudu & @pradeep_ch .

Discussion:
CSV file are the format of rows and columns data with Comma Separated Values.
Each line in the CSV file consider as a row and the value separated by comma symbol are consider as a individual column.

CSV file are easy to store the data in form of string format but, we can’t perform advance level of operation as we do in Excel.

Solution:
Considering the exception handing scenarios

Step-1 : Assign the CSV file path to a variable.
In my example, I have used Relative Path and converted the into Absolute Path using Path class

Path.GetFullPath("Data\Input\challenge.csv")

Step-2 : Validate the file in the path is exist or not
By using Path Exist activity, we can find the result through Boolean data type

Step-3: Read the CSV File
Read the CSV data using Read CSV File activity with input parameters as CSV File Path, Has Header property to be check if the CSV has a header and the output is in Data Table data type.

Step-4 : Validate the data table value with condition
Validate the data table data read from CSV file and handle the scenario with valid log message.

dtCSVOutputDataTable IsNot Nothing AndAlso dtCSVOutputDataTable.RowCount > 0

Step-5 : Convert the Data Table to String and display the result
Use Output Data Table activity to convert the Data Table to String type and display the result using Log Message activity

Source Code
ReadCSVAndDisplay.xaml (12.2 KB)

Thanks,

[Akash_Javalekar1 (Akash Javalekar)]

Hi @loredana_ifrim @pradeep_ch @pathrudu
Thank you so much for organizing this challenge i would say this is really something show our skills where we can implement our skills it helps me lot to boost up my knowledge
AutomationChallenge3.zip (3.6 KB)
.

Please find attached solution.
Looking forward for your feedback.

Regards,
Akash Javalekar

[Prasanna_Jarapala]

Hi Team, @pradeep_ch @AutomationX_by_Kiran @pathrudu @loredana_ifrim

Thank you For the Knowledge Gaining Series, i will be waiting for the next Series of Challenges.
Please find the attached solution submitted below

Challenge3_ReadingCSV.zip (47.3 KB)

[Vinit_Mhatre (BotBuilder)]

Hi @loredana_ifrim

Thanks for presenting the challenge @pradeep_ch , @pathrudu and @AutomationX_by_Kiran

Here is my submission

Input:

Workflow:

String.Join(Environment.NewLine,
                        (From row In Out_DT.AsEnumerable()
                         Select String.Join(",", row.ItemArray.Select(Function(x) x.ToString()))).ToArray())

Output:

Challenge3_ReadingCSV.zip (3.4 KB)

Regards,
Vinit Mhatre

[ronak.patel]

Hello, @loredana_ifrim ,@pradeep_Ch,@AutomationX_by_kiran and @pathrudu

Please find attached my workflow for Beginner Challenge #3. Thank you for organizing this beginner challenge series.

Challenge 3.zip (3.6 KB)

Best Regards,
Ronak Patel

[rob_lavelle]

Hi ,

Thanks for the challenge @AutomationX_by_Kiran , @pathrudu , @pradeep_ch & @loredana_ifrim .

Attached the Solution
Challenge3_Hyperautomation.zip (3.8 KB)

[Kritika_M_s]

Hi Team ,

It was an amazing series of learnings , kudoos to MVP’s @AutomationX_by_Kiran , @pathrudu , @pradeep_ch & @loredana_ifrim .
Begineers Challenge_3.zip (3.7 KB)

[Valli_Viswa_Varshini (Valli Viswa Varshini M)]

Hi @loredana_ifrim , @pradeep_ch , @AutomationX_by_Kiran and @pathrudu

Thank You for organizing this challenge
PFA my solution for Challenge #3

Challenge_3.zip (3.1 KB)

With Regards,
Valli Viswa Varshini M