Error in add data row output

Help Studio
, ,
1

hi, i wish to select 5 specific columns from my workingsheet to paste into another excel, im trying to do so by getting the value of the 5 columns and saving into 5 variables, them builidng a empty datatable with the headers, then adding data row to the new data table, but this error pops up.

image
image1920×1080 252 KB

my scope for all variables is the largest, which is the whole project. anyone knows how to solve this error?

2

Hi @Pyx

Please give a try with

New Object(){yourvariable1, yourvariable2, etc...}

image

Regards

3

Hi @Pyx -

First, you define the variables, partnumber, Qty etc in the variables panel. Now to go ArrayRow field of Add Data Row activity, use your variables in the below format

{partnumber, partdescription,Qty,materialPrice}

Picture1

4

hi i tried, but the output is “TableName” instead of the values… can u explain what the suggested formula is doing?

5

hi, its throwing error

image
image1920×1080 213 KB

6

@Pyx - Can you confirm all those variable types are string or no

7

not all are string, i used .tostring to convert, but the output is wrong

8

image

this is the output… in my output worksheet, it is blank

9

What do you mean with “output”?, add data row will add the values in the order you are adding your values

New Object(){yourvariable1, yourvariable2, etc...}

you need to replace your own variables for “yourvariable1” etc… Also add the datatable you want to add those values, you also need to make sure that the number of values that you are adding, could not be more than the columns of your datatable

Regards!