Forum Engagement Daily Reports

[system]

Daily Forum Report | 21 April 2023

Top 3 Topics with Most Views

Need linq query for multiple filter made by @RAKESH_KUMAR_Tiwari with 64 views.

Syntax result in string for List array of string with Invoke Method Add made by @YangYang with 56 views.

Update ServiceNow Record made by @gary.cobden with 54 views.

Top 3 Topics with Most Replies

Need linq query for multiple filter made by @RAKESH_KUMAR_Tiwari with 27 replies.

Compare Excel files to get matching rows based on a specific column made by @MEGHA_cs with 22 replies.

How to check the queue item based on the condition? made by @Vrishchik with 17 replies.

Top 3 Users Who Posted The Most

@Anil_G made 79 posts!

@Srini84 made 34 posts!

@supermanPunch made 23 posts!

Top 3 Most Liked Posts

This post made by @Ricchch received 2 likes!

Saving an excel with one extension type to another type

Thank you to all, I will work on that today… and then i come back to you . really appreciated your advices. Ric

This post made by @marian.platonov received 2 likes!

Python Scope: Error initializing Python engine - Can't RUn python script

If you are using Python 3.11.x it will not work in UiPath Studio at this moment. I tested with a Python 3.10.10 64-bit and it is working. In order to check your Python version, you can run in cmd.exe the python --version command.

This post made by @Anil_G received 2 likes!

LINQ query to extract lyperlinks from excel

@Ray_Sha1 Please try as @supermanPunch mentioned My bad that I just checked and I dont see url being extracted And you can try this formula as well =MID(FORMULATEXT(A2),13,FIND("""",FORMULATEXT(A2),13)-13) cheers

Top 3 Most Liked Solutions

This solution provided by @marian.platonov received 2 likes!

Python Scope: Error initializing Python engine - Can't RUn python script

If you are using Python 3.11.x it will not work in UiPath Studio at this moment. I tested with a Python 3.10.10 64-bit and it is working. In order to check your Python version, you can run in cmd.exe the python --version command.

This solution provided by @Yoichi received 1 likes!

How to convert EXCEL table?

Hi, How about the following? dtResult = dt.AsEnumerable.SelectMany(Function(r) Enumerable.Range(1,3).Select(Function(i) dtResult.LoadDataRow({"",r("Company"),r("Code")}.Concat( r("Employee ("+i.toString+")").ToString.Split({"/"c})).ToArray,False))).Where(Function(r) Not String.IsNullOrEmpty(r("Employee Name").ToString)).CopyToDataTable [image] Sample20230421-2Lv2.zip (21.2 KB) Regards,

This solution provided by @Anil_G received 1 likes!

How to get files from all duplicates folder name and then store al files in a new foder with the same name

@indiedev91 you can use variable in place of 3211…you can have whole of this inside a loop for each crn you have… your for each folder in folder will get each folder starting with 3211 or the crn …so if there are duplicates it would loop through those folders as well If you dont have those activities then use directory.GetDirectories("Folderpath","3211*") and directory.Getfiles(currentfolder) Both of the above expressions will give you array of strings/paths…use for each activity adn change …

---

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.