Hi,
I will check your updated workflow and get back to you with the results.
Thank you for helping,
Mahi
Hi,
I will check your updated workflow and get back to you with the results.
Thank you for helping,
Mahi
Hi,
Your most welcome. Any time. Please try and let us know. Appreciate your efforts on this requirement.
Can we use two data scrapping activities based on iterations like
if (index =1)
{
scrape both the columns(data scrapping )
}
if(index >1)
{
Scrape only column2 (data scrapping)
}
Thanks,
Hi @Robinnavinraj_S ,
Thanks for your quick response. It is not fixed like how many times we have to use extract datatable since we are clicking some link and getting tables. The issue raised by @Mahimahi . Could you pls redirect your suggestion to @Mahimahi . Thanks again.
Hi @Mahimahi
As @Robinnavinraj_S suggested, can you please try the above and let us know?
@kirankumar.mahanthi1 put lot of effort of this thread. Great
Thank you.
I just implemented your flow. Am able to write the data using append from 2nd iteration.
But my concern here is I need to delete 1st row from 2nd iteration and only append 2nd row to excel. This is not happening.
Thank you,
Mahi
Hi @Mahimahi ,
Are you talking about headers(First row). Append range activity have inbuilt capability to ignore the headers. if you want you can delete the first row by using delete rows activity before appending the data. thanks.
Hi @sowmya.krishna ,
You have to provide row number under the position to delete the specific row. No of rows should be one of you want to delete only one row. Thanks.
Hi @kirankumar.mahanthi1,
I have already passed value 1 and its not deleting row.
Could you please tell how to pass value.
Thanks
Hi @Mahimahi ,
insert/Delete rows activity used to delete the row in the excel itself. do you want to delete the row in data table use remove data row activity in uipath.
https://docs.uipath.com/activities/docs/remove-data-row
We are little bit confusing whether @sowmya.krishna and @Mahimahi both are same. i replied to the above post since i thought it is related to delete rows in excel.
I think you stucked with appending the data after each iteration!
Your Actual actual Process Up to transposing
After that Use Path Exists and write a dummy excel file name as below
Yourfull path with the file name C:\users\folder\Filename.xlsx
use if Condition and pass the out of the file exists!
If Exists Then Use Append Range with the datatable
Else use write range!
Regards
Maybe they are confused and wrote my name in their post.
I want to delete 1st row in datatable after datascraping (not in excel)and write remaining rows to excel.
I have used remove datarow and then used append range. The data is appending from 1st column. But I need data to be appended from second column. Is this possible.
I have attached a sample of excel. I am getting which have highlighted in yellow but I need data like itβs in blue highlighted color.
Thanks