วีดีโอ

Most welcome!

Thank you brother your feedback is much appreciated.

docs.uipath.com/activities/other/latest/productivity/google-workspace-sheets-for-each-row-connections

Out of the box model.

You mean you have already sent the command to start a job and for the second job you want to wait for a minute and then send the command to run?

@@robobixyes. As i m using windows server for bot machines so it takes time to sign off the session. Now after api is called when another process start running on the same machine, the previous process is not yet finished signing off

​@@chiragpatel6204 please confirm if both the processes are background process or foreground. If both are foreground then two processes can be run in parallel.

Hib brother can you please let me know the date string and the expected format that you want.

Glad it was helpful!

This is a kind of cosmetics thing that you have to do on your own, you have to attach the flow decision threads in such a way that it does not look complicated.

Which method is causing the issue?

@@robobix token is generated but not getting complete token

@dhagechetan can I see how you are getting the token?

It should not affect the process by upgrading the packages for the existing workflow. Basically the new version comes with some patch updates.

At the write cell activity put a brake point and check whether the parameter you are passing to the write cell activity has values or not. means one of the variables is null or not initialized with value properly or some of the arguments are not passed

Regex is kind of a thing which gives you the result based on the pattern matching, if the specific pattern you are looking for in a huge amount of data in that case it will return the pattern matching result else it can return some garbage or null value. but as per you requirement it seems you do not want the null values, so as an alternative what you can do is you can implement a if condition to check if you are getting the null value in that case you can assign some customized value as per you need.

@@robobix in that case when regex not match i wamt that incorrect value as it is is it possible or need to do excel formulaes

Please comment the specific topic related to this you want me to cover.

There is the option to pass the specific date and time in the filter to read the email either you can do that way or you can read all the email and then validate the date and time

You are using xls or xlsx file. Try Upgrading or downgrading the excel package and also restart the studio as well once.

I'm using xls file. will try to upgrade or downgrade the excel package@@robobix

Our pleasure!

may I know your requirements what exactly requirements, basically we can use System.RegularExpressions.Regex.Matches for regex filtration, now sure about your requirement.

@@robobix i had one excel column with different formats need to filter that through regex ?

@@suraj_singh321 you can use this expression dtInput.AsEnumerable().Where(Function(row) System.Text.RegularExpressions.Regex.IsMatch(row("ColumnName").ToString, "YourRegexPattern")).CopyToDataTable()

Check if the file is not opened before accessing the file, this error occurs when the file is already opened and being used, in case if the file is closed and still you are getting an error make sure to kill the Excel and then try to read the file again.

@@robobix How to kill the excel because it's only error when closed file. if excel alread opened it's no error.

you can use Kill Process activity to kill the excel

In the description you can see there are two expression first one is the vb.net expression where I have used the select method in the square brackets, usually in vb.net the square brackets [] are used for late binding, however in this context, it is used to access Select method.

Yes, it's faster than the normal join activity

@@robobix You didn't use linq !! It's normal loop

@@fayad99955 ok boss, if you want this topic using Linq I will do a separate video on that

@@robobix Thanks I'm waiting 😊

can you share the file to me over the email and ping me on the number given at the banner of the channel

you can follow this learn.microsoft.com/en-us/dotnet/csharp/linq/

Hi @anishkumar2175, you can get the contact from the channel banner.

Pls try the below query: ExtractDataTable.AsEnumerable().Select(Function(y) y(0).ToString).ToArray()

@@robobix the header is not included.

These types of error occurs when there was another Office Installation. Please try to uninstall the unnecessary version and then run your code.

Video is already uploaded to transpose the datatable in case of dynamic column name you can give the index of columns instead of giving the name. Find the link below th-cam.com/video/BsmhARfNKpc/w-d-xo.html

Thanks, Sure

Apologies, what exactly your expectation is?

Hi suraj_sing321 you can refer to this video th-cam.com/video/g2lln0pWBMk/w-d-xo.html here I have used the Dataview method that will give you the flexibility to rearrange the columns as per your requirements. dt.AsDataView().ToTable(False,"col1","col3","col2")

Have a look at this thread this will clarify your doubt help.openai.com/en/articles/6891831-error-code-429-you-exceeded-your-current-quota-please-check-your-plan-and-billing-details

Create a new accounts and get free token or you can buy the token also.

To read different sheets in a single shot is not possible, however, to read the different sheets you can get all the sheet name in a variable and then loop all the sheets and read it one by one

Yes

Can I get your requirement?

Hi @robinsonrex1, Thanks for your feedback we will make sure to explain the syntax next time. The linq query is already there in the description of the video.

Yes you can

1. Build data table with two columns key and value. 2. For each loop for dictionary 3. for each item Add data row ArrayRow{item.key, item.value} output of build data table

Hi, Instead of Contains method you have to use Equals which will give you an accurate result.

@@robobix the date is not recognised dynamically... Even if we use contains or equals

@@SrinivasReddy-fc5ol could you please share your input and expected output over email I will try to create the solution and share it with you ☺

You can replace group.count with grp.Sum(Function(x) Convert.ToDouble(x("ColumnNameToSum").ToString))

@@robobix Thanks

Very thanks Sadi, thanks for being with us.

You can apply the same logic to "the "Size" column as I have done for the Type and Destination columns.