I’m using data scraping to get title and URL from a website. But the URL which is stored in excel is missing “https://www.sgs.com”, rather than storing full URL it stores “/en/news/2021/01/safeguards-01021-cen-publishes-en-71-4-2020-experimental-sets-for-chemistry-and-related-activities”
I have used for each row
URL is column name
Is there any other way to add specified prefix into each row of a column
@tanv.Uipat …use .insert function which will insert your url to already existing cell
Welcome to forum
In addition to what @prasath17 said.
There is another way to do this without looping.
like after extracting the datatable containing url and text and store in dt1 variable.
Use this code in invoke code activity by passing the dt1 variable as In/Out type argument.
then write the dt1 in a excel file.
The end result got is as
Try this workflow
process1.zip (601.5 KB)
Hope it helps you
Mark it as solution if it resolves ur query
Yes I’ve tried using that also
But it gives same result as above.
Yes it works up to the mark
Thank you so much
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.