REFramwework, DataTable, Assing

Help Studio
1

image
image1918×979 107 KB

I’m working on a reframework.
I want to assign the data I got from get text to in_Data with assing.

2

I’m taking a guess here but you’re trying to take a single string variable and inserting it into a data table variable?

What you might be looking for is Add Data Row and define your string as part of a string array in the ArrayRow, depending on how many columns you have in your configured DataTable.

3

Hello @Yurdanur_Yusuf ,

in_Data variable is declared as DataTable type. It should be a String.

Best regards,
Marius

4

Context is important here.

I can agree with Marius, if this is the only piece of data you need. But it is an inArgument, so I make the assumption there is already existing data in the table. If you convert it to String, then you’re overwriting the existing data.

Yurdanur, you may need to elaborate on what you’re trying to accomplish.

5

how can i convert to string with assing

6

You don’t convert an existing Argument type using an Assign activity.

But the question is, what are you trying to do with this data? why are you using an in Argument if you are setting it in this workflow?

7

We got a data table from the web with data scraping
I added a column
I want to add get text outputs to appropriate columns

8

So how do you know which row to use?

I’m assuming you are adding “Vienna” to an existing row. Are you using a For Each Row loop? Or do you know the row index where this piece of data goes into?

9

You can use an assign activity if you know your row index:
in_Data.Rows(#).item(“YourColumnName”)
where # is your row index starting at 0 for row one.
then the value of the assign activity is your string with “Vienna”, given that the column type is String.

11

Screenshot (2)
Screenshot (2)1920×1080 270 KB

i tried but it didn’t work

12

Hello @iremdgn42 , @iremdgn42 ,

  1. Extract your desired data:

image
image1289×359 22.8 KB

  1. Build a datatable (a column for each type of information you would like to extract) where to store the extracted data:

image
image1277×340 14 KB

  1. Add a new row (1 row per country you may use):

image
image1287×330 20.4 KB

  1. Use the assign aforementioned by @devroen :

image
image1289×261 15.6 KB

Hope it clarifies your issue!

Best regards,
Marius

13

hi i want to creat a row and perform operations with that row

14

and with assign

15

Hi @iremdgn42 ,

In order to succeed with the activities, I would suggest to take a look over the followings:

If some blocking points or errors appear, then we should address them point by point :slight_smile:

Best regards,
Marius

16

Quick note on this; in the screen shot you left # in place, which should have been the index number of the row you wish to edit. If you want to edit row 1, the index is 0. If you want to edit row 17 the index 16. (Basically, row index is row -1 because the row index starts at 0.)