# Data scrapping with same column name

**URL:** <https://forum.uipath.com/t/data-scrapping-with-same-column-name/234565>\
**Category:** Help\
**Tags:** data-scraping, datatable, uiautomation, activities\
**Created:** [June 29, 2020, 1:30pm UTC](https://forum.uipath.com/t/data-scrapping-with-same-column-name/234565 "2020-06-29T13:30:50Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![MaxyArthes](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/maxyarthes/32/64395_2.png) [@MaxyArthes](https://forum.uipath.com/u/MaxyArthes)\
**Post date:** [June 29, 2020, 1:30pm UTC](https://forum.uipath.com/t/data-scrapping-with-same-column-name/234565/1 "2020-06-29T13:30:50Z")

</div>

Hello, I am Data Scraping a table in a program, but there 2 columns having the name ‘Ligne’. I only need the first column but what happenings now is that the first column get replaced by the second.

Is there a ways to use Data Scraping to get only the first 3 columns and ignore the rest? Or any others possible solution to this problem.

Thanks!

---

<div class="post-metadata">

**Author:** ![Srini84](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/srini84/32/464032_2.png) [@Srini84](https://forum.uipath.com/u/Srini84)\
**Post date:** [June 29, 2020, 3:37pm UTC](https://forum.uipath.com/t/data-scrapping-with-same-column-name/234565/2 "2020-06-29T15:37:20Z")

</div>

> [@MaxyArthes](#):
>
> a table in a program, but there 2 columns having the name ‘Ligne’. I only need the first column but what happenings now is that the first column get replaced by the second.
> 
> Is there a ways to use Data Scraping to get only the first 3 columns and ignore the rest? Or any others possible solution to this problem.

@MaxyArthes

Can you share us the sample screen of the table and output?

Thanks

---

<div class="post-metadata">

**Author:** ![MaxyArthes](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/maxyarthes/32/64395_2.png) [@MaxyArthes](https://forum.uipath.com/u/MaxyArthes)\
**Post date:** [June 29, 2020, 5:32pm UTC](https://forum.uipath.com/t/data-scrapping-with-same-column-name/234565/3 "2020-06-29T17:32:52Z")

</div>

Sadly I can’t as even in DEV, the information still must be protected.

But it’s just a normal table, just as fake ex:

```
ID Name Surname LastName Surname
1 Alexandre Alex Duchenes Alexi

```

so in this case, the column that cause a trouble would be Surname, as the outpout would be:

> ID Name Surname LastName  
> 1 Alexandre Alexi Duchenes

and the information I actually need, is the first Surname column, so “Alex”

---

<div class="post-metadata">

**Author:** ![ppr](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ppr/32/464097_2.png) [@ppr](https://forum.uipath.com/u/ppr)\
**Post date:** [June 29, 2020, 5:43pm UTC](https://forum.uipath.com/t/data-scrapping-with-same-column-name/234565/4 "2020-06-29T17:43:56Z")

</div>

@MaxyArthes  
Instead of grapping the entire table at once you can configure the datascraping column wise.  
 ![grafik](https://global.discourse-cdn.com/uipath/original/3X/a/7/a76e4b3081ed9885d4a6375f585eff480ee423e0.png)  
Nein = No

Within the configuration Process the columnname can be configured manually  
 ![grafik](https://global.discourse-cdn.com/uipath/original/3X/a/e/aee375eca5edaf35ef73d076e4a7d2875d941a15.png)

 ![grafik](https://global.discourse-cdn.com/uipath/original/3X/6/5/65da81cc20a94497c178293e04cf6e22e775e9f5.png)  
Extract correlated Data will be used for defiing the next column

---

<div class="post-metadata">

**Author:** ![MaxyArthes](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/maxyarthes/32/64395_2.png) [@MaxyArthes](https://forum.uipath.com/u/MaxyArthes)\
**Post date:** [June 29, 2020, 6:14pm UTC](https://forum.uipath.com/t/data-scrapping-with-same-column-name/234565/5 "2020-06-29T18:14:03Z")

</div>

I don’t have that question, when I use “Data Scraping” and select a column in the table, it’s just select the whole table without asking any further question, it’s get me to preview data page and the “Extract Correlated Data” button don’t exist there ☹
