Join multiple array together

Help
, , , ,
1

I Have 3 arrays with different filters that i need to join together and write into an excel sheet, The first array needs to occupy first 2 columns, 2nd array for 3rd column and 3rd array for 4th column.

Using assign activity

Object1.Join(Object2).ToArray

will cause the 2nd array values to appear on column 1 under the 1st array’s values.
how do i join them so that they are at their respective columns?

2

Meant to say

object1.union(object2).ToArray

instead of join

1 Like
3

Instead of filtering to Array , Can you take it as seperate data table or data column ?
Can you Provide some sample XAML if possible ?

4

@Priyanka_Ramesh
Book1.xlsx (18.9 KB) tessst.xaml (18.9 KB)
Here you go, the xaml and the sample excel.
Basically i am trying to sum up column “Value” with the same cycle number but with different filters(combinations of “Condition A” & “Condition B”) and then put it in the “SumByCycle” sheet. If there is a better way to do it than what i am doing, i am all for it.

Note that i have not added the 3rd filter in yet

1 Like
5

I want duplicate values also from both arrays.

Arr1
(Ab,tc,Ab,jj)
Arr2
(TR,jj,AP,Kk)

Output
(Ab,tc,Ab,jj,TR,jj,AP,Kk)

6

@Mansi_Mhatre
Arr1.Concat(Arr2).toArray

4 Likes