Create data table and assign values from list

Help Activities
, ,
1

Hi All,

I am seeking some advice on how to implement the following.

I have a list of variables with several variables in it e.g. {A, B, C, D}

Each variable has a corresponding value with Double datatype.

I wish to build a datatable and add those variables with their values.

image

The expected outcome would be:

image

2

Hi @calvin.tan ,

Can you pls confirm is the data stored in any document or pdf , pls attach the input

3

Hi,

You have to iterate on list and use Add Data row activiy for each item in the list.

Provide input as Array Row to the Add Data Row activity.

E.x. ArrayRow = {“0001”, item.ToString, Corresponding_variable_Value}

Pls mark it solution if it solves your issue.

Happy Automation :slight_smile:

Thanks

2 Likes
4

Hey @calvin.tan ,
Can you please share how your input is stored in the list.Is it all the 3 columns are stored in list or any one .Please let us know so that we can provide a better solution without assuming.

Regards,

5

The list contains a collection of variables and the value is assigned to each variable.

Example:

list = {A, B, C, D)
A = 0.1234
B = 0.2345
C = 0.3456
D = 0.4567

6

Hey @calvin.tan

image
image928×86 4.25 KB

List fporum.zip (42.7 KB)

Hope this will help
Cheers.

1 Like