Modify default data table

Help
, ,
1

Hi Guys,
Please assist me with this workflow.
my step is extract data from web for two column one is for title another is url. I have used data scrapping but complete url not extract by it. That’s why i need to modify url column. Like this
(“https://t***.net” & row.Item(“Column2”).ToString)

After that i have a excel file where store some email in excel row. Finally email send to all extracted data from each excel email.

Workflow and workfile
workflow.zip (42.5 KB)

Thanks

2

@Jesmine

Check below for your reference, how to set the value in the datatable

Hope this helps you

thanks

3

Hi @Jesmine do u need to send excel data extracted one as attachment or as in body itself?

4

Thanks try to assist.
Not attachment, it should be email body
like:
Title :fjfkfhdsjkf
url:mknsdnf.com

Title :fjfkfhdsjkf
url:mknsdnf.com

Title :fjfkfhdsjkf
url:mknsdnf.com

and so on

5

Can u say how url looks like in final?

6

hey @Srini84,
Thanks try to assist
can you help part of the workflow?
I have used data scrapping for web data extract. Data like Title and Url. I need add string value for url portion.
“fdfd.com” + row.Item(“Column2”).ToString
After adding this it’s make a new data table like DTNew
Is it possible?

7

@Jesmine

You can use assign activity, check below

Dt.Rows(rowNumber).Item(ColumnName).ToString = “fdfd.com”+row.Item(“Column2”).ToString

rowNumber can be replaced with RowIndex of Foreach, to do all for rows in the datatable

Is this the one you are looking for?

Thanks

8

look i need to modify for this

image
image1123×424 40 KB

finally make new data table
newDT have modified with url

9

Main (2).xaml (12.9 KB)
Check this one.

10

Hi @Jesmine please look at this workflow
workflow.zip (47.6 KB)

I had made a lot of changes to it to make it simpler.

Hope it helps you
Mark it as solution if it resolves ur query

Regards

Nived N

Happy Automation