Forum Engagement Daily Reports

[system]

Daily Forum Report | 19 June 2024

Top 3 Topics with Most Views

system.collections.generic.IEnumerable<system.text.regularexpressions.match> not taken my varibale scope made by @shaik.muktharvalli1 with 52 views.

How to compare 2 excel file and store data into another file made by @lakshmi.mp with 51 views.

Exception has been thrown by the target of an invocation in SmartSheet activity made by @Venkatraj_WaMDS with 45 views.

Top 3 Topics with Most Replies

system.collections.generic.IEnumerable<system.text.regularexpressions.match> not taken my varibale scope made by @shaik.muktharvalli1 with 34 replies.

How to apply multifilter at the same tile in datatable made by @T_Y_Raju with 19 replies.

Exception has been thrown by the target of an invocation in SmartSheet activity made by @Venkatraj_WaMDS with 14 replies.

Top 3 Users Who Posted The Most

@ashokkarale made 31 posts!

@Anil_G made 30 posts!

@anilkupatnaik made 23 posts!

Top 3 Most Liked Posts

This post made by @Parvathy received 2 likes!

How to filter the current date using linq

Hi @lakshmi.mp Check the below workflow: First Assign: Bool_dt = If((From row In dt.AsEnumerable() Where row("Published Date").ToString.Contains(DateTime.Now.ToString("MMM-dd-yyyy")) AndAlso row("Recent Published Date").ToString.Contains(DateTime.Now.ToString("MMM-dd-yyyy")) Select row).Count() = 0, True, False) Bool_dt is of DataType System.Boolean Assign inside in If: filtered_dt = (From row In dt Where row("Published Date").ToString.Contains(DateTime.Now.ToString("MMM-dd-yyyy"))…

This post made by @Sai_chnadrika_Kopparapu received 2 likes!

How to remove [ ] from column in excel

@lakshmi.mp [image] [image] Output: [image] Regards,

This post made by @anilkupatnaik received 2 likes!

Need to get queue count through LINQ

Hi @JITU99 If date1 and date2 are fixed and if you want to use the excel data, then you can use the process suggested by @Anil_G If you want to get the data directly from the orchestrator, then use the get queue items and lets take the output of that activity as queueItems and pass the from and to dates in the properties panel of the Get Queue Items and it works!! After getting the queue data use the below syntax in using assign activity and you can get the success count. successCount = queu…

Top 3 Most Liked Solutions

This solution provided by @Sai_chnadrika_Kopparapu received 2 likes!

How to remove [ ] from column in excel

@lakshmi.mp [image] [image] Output: [image] Regards,

This solution provided by @Anil_G received 1 likes!

How to compare the data and append the extra data

@anjani_priya You can use linq for the same to find extra rows and then use append range with the output Use if condition with Dt2.AsEnumerable.Any(function(x) dt1.AsEnumerable.All(function(y) Not y("CodeColumn).ToString.Equals(x("CodeColumn").ToString)) Then on the then side use assign with Dt2 = Dt2.AsEnumerable.Where(function(x) dt1.AsEnumerable.All(function(y) Not y("CodeColumn).ToString.Equals(x("CodeColumn").ToString)).CopyToDataTable On else side no unmatched rows are there Edit: c…

This solution provided by @Yoichi received 1 likes!

Merging Two Dictionaries - but keep second values as priority

HI, All right, can you try the following? dictFinal = dict1.AsEnumerable.Where(Function(kv) not dict2.Keys.Contains(kv.Key)).Concat(dict2.AsEnumerable).ToDictionary(Function(kv) kv.Key, Function(kv)kv.Value) [image] Sample Sample20240619-1 (3).zip (2.7 KB) Regards,

---

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.