Forum Engagement Daily Reports

[system]

Daily Forum Report | 22 July 2022

Top 3 Topics with Most Views

UiPath Apps Accordian to use for free made by @Vajrang with 57 views.

How to create a running number made by @Alfred_Gan with 48 views.

How to get time long of audio by uipath made by @Bin_Bin with 42 views.

Top 3 Topics with Most Replies

How to get time long of audio by uipath made by @Bin_Bin with 24 replies.

How to extract table from application made by @minal.patil with 24 replies.

How to create a running number made by @Alfred_Gan with 15 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 55 posts!

@Veera_Raj made 23 posts!

@ushu made 16 posts!

Top 3 Most Liked Posts

This post made by @kumar.varun2 received 2 likes!

Can any one help me, need to send combinations of matched rows

Hi @saritha_panguluri Try this approach [image] ( From row In dt_Data Group row By k1=row("Purchase Requisition").ToString.Trim, k2=row("Scode").ToString.Trim Into grp=Group Select dt_Queue.Rows.Add({k1,k2, String.Join(",", grp.Select(Function(gr) gr("Item of requisition").ToString))}) ).CopyToDataTable xaml for reference SendCombinationOfMatchedRows.xaml (7.6 KB)

This post made by @li.yu received 1 likes!

有中国的同事吗？

弄个VPN还是挺方便的，遇到问题Google都能解决。

This post made by @Praveen_Vs received 1 likes!

The bot needs to be triggered 2 times in a day, Every mon-fri. The time is 10am & 3.30pm. Can we able to achieve this by using cron expression?

These are two separate expressions right? So need to use two triggers for each cron expressions ? @Rounak_Kumar1

Top 3 Most Liked Solutions

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

Can any one help me, need to send combinations of matched rows

Hi @saritha_panguluri Try this approach [image] ( From row In dt_Data Group row By k1=row("Purchase Requisition").ToString.Trim, k2=row("Scode").ToString.Trim Into grp=Group Select dt_Queue.Rows.Add({k1,k2, String.Join(",", grp.Select(Function(gr) gr("Item of requisition").ToString))}) ).CopyToDataTable xaml for reference SendCombinationOfMatchedRows.xaml (7.6 KB)

This solution provided by @THIRU_NANI received 1 likes!

CopyPaste

Hey! Welcome to community! Your DestinationCell should be the Range “C2:C12” Your DestinationSheet should be the sheet Name “Out1” Could you please interchange the data between the DestinationCell and DestinationSheet Reference: Regards, NaNi

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

How to sum each data and get avg?

Hi @yigit.aybey Try this approach [image] ( From row In dt_Data Group row By k= Strings.StrConv(Regex.Replace(row("City/Town").ToString, "\s+", " ").Trim, VbStrConv.ProperCase) Into grp=Group Let avg = grp.Average(Function(gr) Double.Parse(gr("Price").ToString.Replace("TL", "").Trim(), CultureInfo.GetCultureInfo("tr-TR"))) Let sum = grp.Sum(Function(gr) Double.Parse(gr("Price").ToString.Replace("TL", "").Trim(), CultureInfo.GetCultureInfo("tr-TR"))) Select dt_Result.Rows.Add({k, grp.…

---

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.