Hello.
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)
Hi.
How about specifying a range such as “A: H”, “I: P” in “ReadRange”, deleting duplicate rows and then merging?
Thanks.
-Tera
Hello @tera
Thank you for your reply.
I did like you said and it still doesn’t remove the row.
Help me…
@hsupyaewoon
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”.
Thanks.
-Tera
I am sorry.
It’s removed correctly.
But the data from first row doesn’t come out.
How do I merge it?
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.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.