Forum Engagement Daily Reports

[system]

Daily Forum Report | 14 October 2023

Top 3 Topics with Most Views

Paste only values made by @Mohamed_Ameer1 with 37 views.

Reduce Fetched the Data after API Input made by @sneha41 with 36 views.

Process is not going into suspend state made by @RK_S with 32 views.

Top 3 Topics with Most Replies

Paste only values made by @Mohamed_Ameer1 with 15 replies.

LinQ for 2 For Loops and 1 If loop made by @yash.choursia with 13 replies.

Check Dt1 Column1 all Values Exist In the Dt2 column 1 made by @Prateek_Gulab_Pathak with 11 replies.

Top 3 Users Who Posted The Most

@Anil_G made 43 posts!

@Palaniyappan made 15 posts!

@Dilli_Reddy made 14 posts!

Top 3 Most Liked Posts

This post made by @Yoichi received 2 likes!

Update Datatable based on dictionary

Hi, I think it’s better to have the dictionary including datarow in advance. For example, using the following expression. dict = dt.AsEnumerable.GroupBy(Function(r) r("Order").ToString).ToDictionary(Function(g) g.Key,Function(g) Tuple.Create(g.Select(Function(r) r("Shipping").ToString).ToArray(),g.Select(Function(r) r).ToArray)) This way we can easily write to the finalnum to datatable just after calculated, in the loop. Can you try the following sample? [image] Sample Sample20231014-1…

This post made by @Yoichi received 2 likes!

「フォームを作成」の「チェックボックス」にUiPathで動的に生成したJSONファイルを適用したい

BuildDataTableは必須ではありません。上記ではDataTableを生成するために使っているだけです。 ただチェックボックスにするためにはColumnのDataTypeがBooleanである必要があるようなので、その点の工夫が必要と思われます。

This post made by @yash.choursia received 2 likes!

Error while Business Exception or System Exception

Thanks a lot @Shiva_Nikhil and @Anil_G .

Top 3 Most Liked Solutions

This solution provided by @Yoichi received 2 likes!

「フォームを作成」の「チェックボックス」にUiPathで動的に生成したJSONファイルを適用したい

BuildDataTableは必須ではありません。上記ではDataTableを生成するために使っているだけです。 ただチェックボックスにするためにはColumnのDataTypeがBooleanである必要があるようなので、その点の工夫が必要と思われます。

This solution provided by @supermanPunch received 1 likes!

Help / Expert advice needed: PDF Table extraction (Purchase Order to Excel)

@Nilochan , For the sent sample, we are able to get the required Expected Output. You could validate it and test it out with different sample and let us know if it does not work. Regex_Extract_SpecificData2.zip (26.8 KB) However, the other format mentioned in your initial post, will not be handled, it does seem that there are one field added in it and one field removed. So, not an uniform extraction. If the extraction also needs to be adhered to different formats, we would need to know how m…

This solution provided by @Dilli_Reddy received 1 likes!

Reduce Fetched the Data after API Input

Hii @sneha41 Try this JSONOBJECT(“ActiveSystems”)(0)(“PhoneNumber”).ToString.SubString(2) or JSONOBJECT(“ActiveSystems”)(0)(“PhoneNumber”).ToString+“.”+JSONOBJECT(“ActiveSystems”)(0)(“PhoneNumber”).ToString.Split(" ")(1) This is helpful for you If anything error please let me know Cheers…!

---

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.