Forum Engagement Daily Reports

[system]

Daily Forum Report | 31 August 2022

Top 3 Topics with Most Views

Extr number from string made by @Yashas_H with 37 views.

How to extract specific data from a JSON payload using SelectToken? made by @KMota with 32 views.

Remove duplicate rows from two datatables based on a specific columns made by @hckwon5 with 29 views.

Top 3 Topics with Most Replies

Separate text and number made by @Sabbir_Anwar with 17 replies.

Argument value not provided made by @Halil_Gezer with 16 replies.

How to download all attachments apart from pdf made by @gokul1904 with 15 replies.

Top 3 Users Who Posted The Most

@raja.arslankhan made 26 posts!

@postwick made 26 posts!

@ppr made 22 posts!

Top 3 Most Liked Posts

This post made by @ppr received 2 likes!

How to check string present in dictionay or not

we do have the ContainsKey(yourKey) / ContainsValue(YourValue) we can use LINQ we can check the keys / the values lists to get a new dictionary similiar to your output we could use LINQ Assign Activity: dictUpdated = (From x in YourOriginDict Let chk = x.Key.toUpper.Contains(YourCheckStringVar.toUpper) Let v = If(chk, "found", "Notfound") Select t = Tuple.Create(x.Key, v)).ToDictionary(Function (t) t.Item1,Function (t) t.Item2) Or (From x in YourOriginDict.Keys Let chk = x.toUpper.Contai…

This post made by @Nitya1 received 1 likes!
https://forum.uipath.com/t/469292/1

This post made by @Lori received 1 likes!

I use LINQ expression should filter one column value which >-1 and <1, However, I cannot get the right data, who can help?

@kumar.varun2 Thanks for you help, seem that I made a mistake, I got the value which I want, thanks you very much!

Top 3 Most Liked Solutions

This solution provided by @ppr received 2 likes!

How to check string present in dictionay or not

we do have the ContainsKey(yourKey) / ContainsValue(YourValue) we can use LINQ we can check the keys / the values lists to get a new dictionary similiar to your output we could use LINQ Assign Activity: dictUpdated = (From x in YourOriginDict Let chk = x.Key.toUpper.Contains(YourCheckStringVar.toUpper) Let v = If(chk, "found", "Notfound") Select t = Tuple.Create(x.Key, v)).ToDictionary(Function (t) t.Item1,Function (t) t.Item2) Or (From x in YourOriginDict.Keys Let chk = x.toUpper.Contai…

This solution provided by @kumar.varun2 received 1 likes!

I use LINQ expression should filter one column value which >-1 and <1, However, I cannot get the right data, who can help?

Hi @Lori Could you give this a try Filter datatable where “AP Invoice Number” = Blank and “AR Invoice Number” not Blank and “Issue Type”=“Price Diff” or Blank and “Diff” column value "-1 < and < 1 ", ( From d In CSVDT.AsEnumerable _ Let APInvoiceNum = d("AP Invoice Number").ToString.Trim().ToUpper() Let ex = d("Issue Type").ToString.Trim().ToUpper() Let diff = Convert.ToDouble(d("Diff").ToString) _ Let c1 = String.IsNullOrEmpty(APInvoiceNum) Let c2 = Not d("AR Invoice Number")…

This solution provided by @Gokul001 received 1 likes!

What is execution trail and what is its use?

Hi @Rohit_More Check the below image execution trail is used to see which are in-progress, Executed, Faulted in the workflow. You must run the process in Debug Mode [image] Check out the docs for more info Debugging Actions. Regards Gokul

[Previous Month] Top 3 Users with the most likes on their solutions

@Yoichi received 54 likes for their solutions!

@ppr received 45 likes for their solutions!

@Gokul001 received 33 likes for their solutions!

---

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.