Forum Engagement Daily Reports

[system]

Daily Forum Report | 27 November 2023

Top 3 Topics with Most Views

How to Rename csv File name made by @NISHITHA with 55 views.

Selector not getting identified and validated made by @Santa_Krish with 53 views.

How to extract financial pdf document and save it to excel without using Document Understanding made by @Lalitha_Selvaraj with 46 views.

Top 3 Topics with Most Replies

How to move cell value using studio made by @Nur_Amin with 21 replies.

How to extract financial pdf document and save it to excel without using Document Understanding made by @Lalitha_Selvaraj with 18 replies.

Time out is much longer than the default 30 seconds - System exception made by @atomic with 14 replies.

Top 3 Users Who Posted The Most

@rikulsilva made 34 posts!

@Anil_G made 31 posts!

@Nguyen_Van_Luong1 made 25 posts!

Top 3 Most Liked Posts

This post made by @ppr received 3 likes!

[FirstAid] - Topic Catalogue

This topic indexes the various [FirstAid] topics. It is also updated when new [FirstAid] topics are published. FirstAid List Data Table Summary Link Keywords This FirstAid tutorial describes how to handle the EXCPTION: "The source contains no data rows" FirstAid DataTable, Exception, This FirstAid Tutorial describes how to analyze and handle DateTime parsing issues FirstAid DataTable, DateTime, Parsing, Invalid Date, Analysis Activities Summary Link Keywords This FirstAi…

This post made by @rikulsilva received 2 likes!

Count no of files in inside folders

Hi @shashank_dullu Try this Directory.GetFiles("Data\Downloading_files\BP41693","*", SearchOption.AllDirectories).Count The * is a wildcard tha you can use for filter file by extension, name etc *.pdf *.xlsx *.txt *.csv invoice*.pdf *2023.xlsx * alone = all files

This post made by @RAKESH_KUMAR_BEHERA received 2 likes!

Introduction to UiPath Remote Runtime | UiPath Automation Developer Professional Exam Preparation

[Introduction to UiPath Remote Runtime | UiPath Automation Developer Professional Exam Preparation]

Top 3 Most Liked Solutions

This solution provided by @rikulsilva received 2 likes!

Count no of files in inside folders

Hi @shashank_dullu Try this Directory.GetFiles("Data\Downloading_files\BP41693","*", SearchOption.AllDirectories).Count The * is a wildcard tha you can use for filter file by extension, name etc *.pdf *.xlsx *.txt *.csv invoice*.pdf *2023.xlsx * alone = all files

This solution provided by @Yoichi received 1 likes!

Join 2 data tables by referencing 1 column

Hi, How about the following? [image] Sample Sample2023112702L.zip (12.7 KB) Regards,

This solution provided by @Anived_Mishra received 1 likes!

How to pick data from an unstructured excel?

Hey all, I got a work around. I got the row number for the Gl and the value above that ow will correspond to the previous Gl and the last GL would be the last row in the excel so it’s all good now. Closing this topic as this has been solved :). Thanks for your responses @Nguyen_Van_Luong1 @Anil_G

---

That’s it for now, see you tomorrow for a new report!

Don’t forget to share ideas for other fun stuff we should add to the reports here.