Put arrays in data table then output to excel

Help
, , ,
6

To anyone who might look into this topic in the future:

This is the scenario:
I have 4 arrays that I want to insert to an excel file:

  • 1st aray(POArray) = {“116808”,“116808”,“116808”}[*]
  • 2nd array(LineItemArray) = {“1”,“2”,“3”}
  • 3rd array(QuantityArray) = {“1”,“1”,“5”}
  • 4th array(ResultArray) = {“YES”,“NO”,“YES”}

[*] the POArray is a new string array and was filled up by the for each loop

and I managed to do this:

image

While I was working on this, I was getting a fourth item in my array. I first removed the last element/item by going to this post: Remove last element/item in an array

but I managed to do the same result by simply adding “-1” in my assign value for setting up a new string array.

image

To those who would like to see the last item removed using the method in the link, remove the “-1” and comment the Assign activity in the “Remove last item in array” CommentOut activity.

image

Check out my revised xaml file here: _test2.xaml (24.9 KB)

Thank you and Good luck! :smiley:

1 Like