Add Variable into DataTable into existing Column

Help
1

Hoping someone can help. I did a web scraping and have recipes in one column, and URL in another. A for each process that goes to the website, gets the ingredients.

From the inital datatable that created the RecipeName column and RecipeURL, I want to add the ingredients as a third column to the existing data table (from the webscraping). The ingredients are trimmed (don’t think that’s correct because theres alot of spaces before and after), and assigned to IngredientsTrimmed. When I go to add data row, It errors. I also didn’t specify which column it should be added to as i’m not sure how.

Once completed it needs to be exported to CSV

So I want this existing CSV from intital data web scraping:

image
image849×121 4.93 KB

To become this:

image
image1046×120 7.19 KB

What I have

image
image449×735 21.7 KB

2

@swanvalkyrie,

If you want to add column only then use Add Data Column activity. it will add column to existing DataTable.

3

I already have, but I cant add the values then into row 2 under the third column

image
image1065×399 13.1 KB

getting this error:

image

4

in Add data row pass three values like {receipename,receipeurl,ingredientstrimmed}

5

I don’t have these variables declared, because they were created through the web scraping. Should I add them anyway? would it leave them blank and only add values into the third column then?

@Teja_L I did what you said but i’m still getting the same for each row error listed above

6

After extracting use get row item to for first column and assign a variable. in similar way for second column also.

7

Should I be specifying which row numbers if the web scraping has several rows filled out?

image
image1144×306 15.2 KB

8

image
image1366×768 149 KB

9

This seems complex :frowning:

10

Is it possible to share you workflow?

you need to use get row item inside for each row .

11

FruitTest2.xaml (29.5 KB)

Ah ok yeah i’m completly stuck with that concept. I’ve been able to learn a bit but can’t wrap my head around this for some reason.

12

HI @swanvalkyrie
FruitTest2.xaml (35.6 KB).
I have changed your workflow based on your requirement. :slight_smile:

image
image1366×768 143 KB

13

Thankyou so much!! I am away from computer at the moment but when I get back on I will check it out. Really appreciate your help and input!

14

Hi Teja,

When loading I get these errors, what dependencies do you have?

image
image1499×714 39.6 KB

15

Install Uipath.Database.Activities package.

16

Still the same, strange?

17

May be studio version different. What is your uipath studio version.Mine is 2018.4.0 .

18

2018.4.4 community edition

19

image
image1366×768 162 KB

20

Ok strange it’s the activities. I have them installed in mine but when I open your file I don’t have any. I’ve redownloaded them but what is write range from? I’ve installed a few but it’s not validating

Ah found it didn’t realise it was on the top right! Will check out package now