Data is appending for column in last

HI All,

I am trying to add new column for the existing excel(after scraping ). This is the way the new column data is adding as below,

This is the logic I have given,

Can anyone pls help this out issue.

Thanks,

1 Like

Hi @sushmitha.e

You no need to do the add data row.

After assign just write the same datatable back to excel.

Thanks
#nK

HI @sushmitha.e

i assume that you have to add new row values to the existing row right ??

After data scrapping

create a new column

then use for each activity to iterate datatable

inside that for each activity use assign activity to add new row values
Ex: Currentrow(2)=value you to insert

Thanks
Robin

HI @Nithinkrishna ,thanks for replying

1 Like

Hi @Robinnavinraj_S , yes I have done the same.

1 Like

just put the write range activity outside of the for each activity

OK,I tried it @Robinnavinraj_S

In the Write Range you need to pass the Output_DT please…

1 Like

yes yes @Nithinkrishna

1 Like

@sushmitha.e Working fine ?

Need to check tomorrow as linkedin session time is finished today for scraping.

1 Like

Its working now, thanks.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.