Hello guys,
I have an excel file with 2 columns, and now I am scraping the third colum,
how can I append each value to the next column to its corresponding value?
| id | description | catalog_number |
|---|---|---|
| 6318960 | 56601G | |
| 6318961 | 56602G | |
| 6318962 | 56603G | |
| 6318963 | 56604G | |
| 6318964 | 56606G | |
| 6318965 | 56609G |
Thank you!
Hi Ionut_Frincu,
In which format is the catalog_number data?
If you have a separate table with an id column you can use an inner join.
It is important you can ensure the data is valid.
Kind Regards
Do you want the catalog_number to be written based on id or are you getting the catalog_number in order?
Hello @Che ,the catalog_number is a string, @Lak_Ui I am getting the catalog_number in order, Thank you!
If it is in order and if the catalog_number in datatable format you can directly use write range activity and specify the proper cell number
and if it’s based on the currentrow id?
There should be id in the scraped data as well and you can use inner join as mentioned by @Che
If you can scrape catalog_number data with the id, it’s best to manipulate the data in memory with an Inner Join, then Write/Append Range the new DT depending on your requirements.
Kind Regards
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.