Filling datatable with data from array

Help Studio
, ,
1

Hello! Please, help me. I have 2 one dimensional arrays and 2 columns in a datatable. How do I fill the first column of datatable with the values ​​of the first array and the second column of datatable with the values ​​of the second array?

2

Hello and good afternoon,

First off I will assume that the arrays are of the same length, if not then you will need two loops instead of a single one. If they are of the same length then you can do as follows

this
this1578×666 32 KB

This will loop through each item in array1 (and assuming they are the same length, array2 as well) and add them as a datarow to your table.

1 Like
3

Thank you for your reply! I did everything as you said, but an error occurred in the “output” field: “add data row: the index was outside the bounds of the array”. Can you please tell me what it might be connected with?

4

In the foreach activity, you must check that array2 has element at count index or not.
IF not, please add blank (“”).

5

thank you for your answer, but I didn’t quite understand what needs to be done. Please show how to check if there is a count element in array2 and where to add (“”) if it is not there.

6

@bolbat_evgenia Does both the arrays that you use have the same length ?

7

Yes, arrays of the same value

8

キャプチャ
キャプチャ1035×591 38.9 KB

This is the check logic in ArrayRow attribute of Add data Row activity

9

ArrayDataToExcel.zip (17.0 KB)

Hi,
Can you please try the attached workflow file
mark as resolved if you got solution

10

@JosephNehl, @khanhpk, @supermanPunch, @Venugopal24 Thank you all very much! I found my mistake, fixed it and everything worked out for me! Thanks!

2 Likes
11

@bolbat_evgenia What was the mistake :sweat_smile:

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.