Forum Engagement Daily Reports

[system]

Daily Forum Report | 13 September 2021

Top 3 Topics with Most Views

Sql insert activity is not uploading data in correct order made by @WASEEM_KHAN with 41 views.

Find perticular date from string made by @ashishmani with 34 views.

How to make a trigger start after every 7 hours and 5 minutes? made by @Dam_Son with 33 views.

Top 3 Topics with Most Replies

VlookUp_Error made by @HeartCatcher with 19 replies.

Find perticular date from string made by @ashishmani with 16 replies.

Create Folder precheck? made by @atomic with 15 replies.

Top 3 Users Who Posted The Most

@Srini84 made 38 posts!

@Palaniyappan made 32 posts!

@Yoichi made 26 posts!

Top 3 Most Liked Posts

This post made by @AndyMenon received 2 likes!

How to pass in a Variable in an Update query

Sorry if I read this wrong, but shouldn’t your UPDATE SQL be: UPDATE dbo.CampaignBatch SET ProcessStatusTypeId=200, YourDateColumn=@YourDateVariable where CampaignBatchId in ('value') ? Where is the column to which you are updating the date to?

This post made by @HANACCHI received 2 likes!

条件分岐についての質問

前日日付 = Now.AddDays(-1) 前日7時 ＝ New DateTime(前日日付.Year, 前日日付.Month, 前日日付.Day, 7, 0, 0) 前日22時 ＝ New DateTime(前日日付.Year, 前日日付.Month, 前日日付.Day, 22, 0, 0) 本日2時 = New DateTime(Now.Year, Now.Month, Now.Day, 2, 0, 0) を用意して、条件分岐に組み入れてみましょう。 Now.CompareTo(前日7時).Equals(1)とか、(0)とか、(-1)を組み合わせて。。。

This post made by @lakshman received 2 likes!

String Split Accordingly Using Split

@Hurmet_Noka Replace Outbound Flight Information text with empty. output = input.Replace("Outbound Flight Information","")

Top 3 Most Liked Solutions

This solution provided by @Palaniyappan received 2 likes!

String Split Accordingly Using Split

Hi you are almost done for first part use this in assign activity str_part1 = Split(Split(information, “Inbound Flight Information”)(1).ToString),“Outbound Flight Information”)(0).ToString.Replace(“-----------------------------------------”,“”) and for second part like this str_part2 = Split(Split(information, “Inbound Flight Information”)(1).ToString),“Outbound Flight Information”)(1).ToString.Replace(“-----------------------------------------”,“”) Cheers @Hurmet_Noka

This solution provided by @Srini84 received 1 likes!

Argument passing issue - NULL outcome

@Jie_Sheng_Ong Check inside the Invoke Workflow [image] you have both Aguments and Variables with the same name [image] Delete the variable used inside the invoke workflow and you are fine to go Hope this may help you Thanks

This solution provided by @Palaniyappan received 1 likes!

Create Folder precheck?

Fine lets go one by one PATH EXISTS is usually used when someone wants to validate whether a folder exists or not before creating it and it is applicable for both files and folders as well. And it depends on scenario, say for example if someone wants to fetch a file from folder once after that file is downloaded but would like to validate whther the file is there or not, there comes PATH EXISTS or if someone wants to see if folder exists first or if not will need to send a mail or need to lo…

---

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.