Forum Engagement Daily Reports

[system]

Daily Forum Report | 02 May 2023

Top 3 Topics with Most Views

Split the text made by @Demo_User with 54 views.

How to get latest download files made by @Suraj_Gaikwad_Nuvama_Grou with 44 views.

How to get over all count of a queue items? made by @Vrishchik with 44 views.

Top 3 Topics with Most Replies

Split the text made by @Demo_User with 22 replies.

How to read ExtractedData in inverse made by @Muhammad_Anas_Baloch with 15 replies.

Two level subfolders help made by @Ricchch with 13 replies.

Top 3 Users Who Posted The Most

@Yoichi made 33 posts!

@Anil_G made 33 posts!

@Srini84 made 27 posts!

Top 3 Most Liked Posts

This post made by @dla0313 received 2 likes!

[ODBC Teradata Driver] Query Timeout Expired

Thanks, yes I increased the timeout to 60 seconds and its working now.

This post made by @Srini84 received 2 likes!

[ODBC Teradata Driver] Query Timeout Expired

@dla0313 You better increase the timeout of the Execute Query activity and see As the default activity timeout is 30 seconds and if the Query is taking more time then you can see this type of errors You can place some delays as well if this is still not working Hope this may help you Thanks, Srini

This post made by @vishal.kp received 2 likes!

Compare a list of mails, using subjects with list of subjects stored in list of string

Hi @Karan_Zaveri , Try this: listMailMessage.AsEnumerable().Where(Function(mail) listSubjects.Any(Function(x) mail.Subject.ToString.ToLower.Trim.Contains(x.ToString.ToLower))).ToList Regards,

Top 3 Most Liked Solutions

This solution provided by @Srini84 received 2 likes!

[ODBC Teradata Driver] Query Timeout Expired

@dla0313 You better increase the timeout of the Execute Query activity and see As the default activity timeout is 30 seconds and if the Query is taking more time then you can see this type of errors You can place some delays as well if this is still not working Hope this may help you Thanks, Srini

This solution provided by @vishal.kp received 2 likes!

Compare a list of mails, using subjects with list of subjects stored in list of string

Hi @Karan_Zaveri , Try this: listMailMessage.AsEnumerable().Where(Function(mail) listSubjects.Any(Function(x) mail.Subject.ToString.ToLower.Trim.Contains(x.ToString.ToLower))).ToList Regards,

This solution provided by @Srini84 received 1 likes!

How to remove empty row in excel for some specific columns

@sathish_Kumar6 You can use Filter Datatable activity and mention your column for example F->“campaign” and put is not empty Then you will get all the values wth the campaign which is not empty Now use Read Range activity to write it back to a new excel Hope this may help you Thanks, Srini

---

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.