How to add each datarow from one excel to another and add another data column into it?

[Vinit_Mhatre (BotBuilder)]

How to add each datarow from one excel to another and add another data column into it and then again add another row from same excel and transfer to the another sheet and same add anoter data column in it…

Above image is my first excel sheet and i want to add this 6 column into another sheet one by one.

Above image is my second excel sheet and i want to add the scraped data into it…

My main goal is to if there is 3products in my sheet then in output sheet it will store the first product information along with the extracted reviews . if there are 60reviews on that product then after 61th row it will add the second product data along with the reviews and this logic will goes on…

How to implement this?

Thanks

[Robinnavinraj_S]

Hi @Vinit_Mhatre

First Create a copy of first excel DT with 4 new columns(Review title, date,Comments)

then use for each to add review
using invoke code with this syntax we can achieve this
Dt.rows.insertAt(datarow,index_you_want_insert)

Thanks,
Robin

[Vinit_Mhatre (BotBuilder)]

is there any possible way to add the extracted datatable into build data table?

[Robinnavinraj_S]

yeah you can directly use datarow inside for each to add rows one by one

[Vinit_Mhatre (BotBuilder)]

okay i will let you know…
Thanks

[Robinnavinraj_S]

okay

[Robinnavinraj_S]

try out this

Sequence1.xaml (61.4 KB)