Oh! Wonderful. That's the video many people are looking for. Thanks QAL for such wonderful videos. It is really helpful😃. This is a kind of real time scenario based activity. Thanks a lot! Keep posting such real time based videos. Much appreciated!👏👏
Nice video. It's an alternative to vlookup and countif in excel. We can use "increment" function to increase the counter value Also, instead of "Assign to number" we van use it in the variable like $RowNum.assign to number$ This will make the bot less complicated. Thank you QAL for the video, I keep on waiting for your notication:))👍👌
I would like to get a tutorial video about read data from excel and update value of a node in xml if that node is found, else continue loop till all xml files updated in a folder using AA 2019
Hi , could you please help on below scenario We have excel data of column with Dates (Ranges from today to 50days) in that need to select dates from +5 days from today how can we do that ?. Ex:- if today is Monday need to select date from Saturday.
In this case, if all three fields were matching, then the required cell value was updated. Suppose 2 out of 3 fields are matching and third field is blank in one of the datasets, and we want to set the required cell in this case. Then how to proceed.
I have my result as a numeric value, but using set cell command i have to put $numericVar.tostring$ and in excel file it shows as warning for each value. How to fix this any suggestion plz?
Hi mam, Thank you for this video. I’m having one doubt.Inorder to update we need to execute that program in each and every time or will it be automatically update?
Hello thanks for the video I have an excel sheet that has 2 columns price and discount I want to count the new price after the discount and store it in a new column how can I do that, please
Hi I am using AA2020 community edition and am not able to find NumberUtilities(Calculation) although increment and decrement are there, whats the alternative if i wish to do a complex calculation? Also we are using the iterator to iterate thru each row, infact we are reading data from each column by $[RecordVariable][Name/Index of Column]$, then do we have any alternative to use the same iterator to write/set value(instead of using a new variable to do the same)?
Hi, it looks strange that Calc action is not present, I'll look at the alternative and will get back to you. It is good to have different variables for read and write , if you are doing these actions together, to avoid the conflict.
Oh! Wonderful. That's the video many people are looking for. Thanks QAL for such wonderful videos. It is really helpful😃. This is a kind of real time scenario based activity. Thanks a lot! Keep posting such real time based videos. Much appreciated!👏👏
Thank you so much, glad to know that you found it helpful
Nice video. It's an alternative to vlookup and countif in excel.
We can use "increment" function to increase the counter value
Also, instead of "Assign to number" we van use it in the variable like $RowNum.assign to number$
This will make the bot less complicated.
Thank you QAL for the video, I keep on waiting for your notication:))👍👌
Could you provide those excel sheets in discription so we can practise
thankyou miss
Hi, your Explanation is incredible, would you please make a video on using Shared session variable
I would like to get a tutorial video about read data from excel and update value of a node in xml if that node is found, else continue loop till all xml files updated in a folder using AA 2019
Please create a video on task "Invoice Extraction" from RPA challenge.
Hi , could you please help on below scenario
We have excel data of column with Dates (Ranges from today to 50days) in that need to select dates from +5 days from today how can we do that ?.
Ex:- if today is Monday need to select date from Saturday.
In this case, if all three fields were matching, then the required cell value was updated. Suppose 2 out of 3 fields are matching and third field is blank in one of the datasets, and we want to set the required cell in this case. Then how to proceed.
I have my result as a numeric value, but using set cell command i have to put $numericVar.tostring$ and in excel file it shows as warning for each value. How to fix this any suggestion plz?
We have one excel file in that we have open, closed and pending actions we need separate actions into 3 excels can you help on this?
Hi mam,
Thank you for this video. I’m having one doubt.Inorder to update we need to execute that program in each and every time or will it be automatically update?
Please do more videos 🙏
Where can I download these two files?
you are awesome !
Hello thanks for the video
I have an excel sheet that has 2 columns price and discount
I want to count the new price after the discount and store it in a new column
how can I do that, please
Please use NumberUtils -> Calc Action to calculate price after discount and write the value in excel
Hello
Hi I am using AA2020 community edition and am not able to find NumberUtilities(Calculation) although increment and decrement are there, whats the alternative if i wish to do a complex calculation?
Also we are using the iterator to iterate thru each row, infact we are reading data from each column by $[RecordVariable][Name/Index of Column]$, then do we have any alternative to use the same iterator to write/set value(instead of using a new variable to do the same)?
Hi, it looks strange that Calc action is not present, I'll look at the alternative and will get back to you.
It is good to have different variables for read and write , if you are doing these actions together, to avoid the conflict.
@@qualityassurancelab7764 Thanks for your kind reply
Hi, please share uipath video thanks
Is there a way to do yh iui s using Uipath?
Yes, please checkout -
ruclips.net/video/tPMBF8lbv8E/видео.html
ruclips.net/video/XmQlvzaHgIw/видео.html
Im also cant find the Calc Function also
I'll take a look, in the mean time, please use Increment action
@@qualityassurancelab7764 I used the increment function but I didn't get the output.
please can you send me the Excel sheet?
Hi could you please suggest what to do in case of lakhs of records in my excel sheet. As it takes hours together when I tried