I am trying to remove only some of the cells from a single row.
Because the data has its own headers in the first row.
In the second row, also has headers again with the first data.
The other rows are fine with each datas.
In this case, I want to remove the excess headers from the second row but want to remain the data from that row.
Can someone please teach me how can I remove it?
I got that data from data scraping but the original data table is a little bit wrong and so I need to remove it by myself in the uipath activity.
Please help me.
There is an attachment file below.
datascraping.xlsx (10.0 KB)
How about specifying a range such as “A: H”, “I: P” in “ReadRange”, deleting duplicate rows and then merging?
Thank you for your reply.
I did like you said and it still doesn’t remove the row.
Is “AddHeaders” checked? If it is checked, please remove it.
If not, I want to check the data table values before and after “Remove Duplicate Rows”.
I am sorry.
It’s removed correctly.
But the data from first row doesn’t come out.
How do I merge it?
@tera I did it like this.
And this error comes out.
I did the same activity and this time,
the different error comes out.
hi @hsupyaewoon, You can use build datatable for specific columns. Create the build data table, then create the columns that you require and then add the data in add data rows, then write in excel.
Thank you so much.
I got it now…
Thank you for your answer.
I will give it a try to your suggestion too.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.