Forum Engagement Daily Reports

[system]

Daily Forum Report | 30 June 2022

Top 3 Topics with Most Views

2つのExcelブックの同じ名前のシート同士を比較したい made by @T_Hirao1 with 36 views.

How to sort data in excel sheet with month names made by @Zeba with 35 views.

Element exits Selectors made by @tkiran with 35 views.

Top 3 Topics with Most Replies

Element exits Selectors made by @tkiran with 21 replies.

Replace characters with nothing using Regular Expression pattern in Type into activity (Type this) made by @Ruxandra_Zamfir with 20 replies.

How to extract data for last 7 consecutive days from an excel data table made by @faiqaqureshi90 with 15 replies.

Top 3 Users Who Posted The Most

@THIRU_NANI made 36 posts!

@Rahul_Unnikrishnan made 25 posts!

@ppr made 18 posts!

Top 3 Most Liked Posts

This post made by @Daniel_Santos1 received 1 likes!

How to get bigInt number more than 15 characters from the database and put it in a string

Hi guys, thanks a lot for the tips. I managed to get around the problem. Forcing to concatenate a letter with a number in the select in the database. This caused the number to be interpreted by uipath as a string. Look select id,cnpj, num_doc_ajustado = concat ([num_doc],‘a’), data_hora, razao_social, local_arq from [bdp].[dbo].[compr] where cnpj in (6xxx55320143,8xx58002,102xxx0000121,42xxx000167,8xxx49130500009) and dsc_stat = ‘CONCLUIDO’ order by dat_hora_ult_alt desc [image]

This post made by @tarik received 1 likes!

Automation Awareness - The Automation Journey - We want to hear your thoughts!

Learning the processes and figuring out the best possible way to apply automation. Improving the automation would be fun too.

This post made by @Rahul_Unnikrishnan received 1 likes!

I want to add days to the current date, can any one help me on this?

Hello @saritha_panguluri Please check the below doc.

Top 3 Most Liked Solutions

This solution provided by @Daniel_Santos1 received 1 likes!

How to get bigInt number more than 15 characters from the database and put it in a string

Hi guys, thanks a lot for the tips. I managed to get around the problem. Forcing to concatenate a letter with a number in the select in the database. This caused the number to be interpreted by uipath as a string. Look select id,cnpj, num_doc_ajustado = concat ([num_doc],‘a’), data_hora, razao_social, local_arq from [bdp].[dbo].[compr] where cnpj in (6xxx55320143,8xx58002,102xxx0000121,42xxx000167,8xxx49130500009) and dsc_stat = ‘CONCLUIDO’ order by dat_hora_ult_alt desc [image]

This solution provided by @nikhil.girish received 1 likes!

Ml ai dataserrvice

Hi @Praveen_Sood basically enterprise trial is provided for 60 days No payment options are asked , nothing to worry about that

This solution provided by @ahmad.sultan received 1 likes!

Unable to use 'forward task' activity

Finally understood the reason of this issue, according to UiPath support the minimum version of on-premise Orchestrator and Action center that supports ‘Forward task’ and ‘Complete Task’ activities is 21.4, and in my case it was 20.10

[Previous Month] Top 3 Users with the most likes on their solutions

@Yoichi received 54 likes for their solutions!

@ppr received 42 likes for their solutions!

@jack.chan received 30 likes for their solutions!

---

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.