<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Append current row to collection 2 when looping through collection 1 in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Append-current-row-to-collection-2-when-looping-through/m-p/67089#M19694</link>
    <description>Hi there.

I am currently looping through a collection and based on a few criterias I then want to append that row to another collection.

Is that possible somehow?

I tried using the "Utility - Collection Manipulation - Append Rows to collection" but that does not seem to work as it copies the whole content of the main&amp;nbsp;collection and I only want the row I'm on in the loop.</description>
    <pubDate>Mon, 10 Sep 2018 17:15:00 GMT</pubDate>
    <dc:creator>stefan.hansen</dc:creator>
    <dc:date>2018-09-10T17:15:00Z</dc:date>
    <item>
      <title>Append current row to collection 2 when looping through collection 1</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Append-current-row-to-collection-2-when-looping-through/m-p/67089#M19694</link>
      <description>Hi there.

I am currently looping through a collection and based on a few criterias I then want to append that row to another collection.

Is that possible somehow?

I tried using the "Utility - Collection Manipulation - Append Rows to collection" but that does not seem to work as it copies the whole content of the main&amp;nbsp;collection and I only want the row I'm on in the loop.</description>
      <pubDate>Mon, 10 Sep 2018 17:15:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Append-current-row-to-collection-2-when-looping-through/m-p/67089#M19694</guid>
      <dc:creator>stefan.hansen</dc:creator>
      <dc:date>2018-09-10T17:15:00Z</dc:date>
    </item>
    <item>
      <title>First you have to add a row…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Append-current-row-to-collection-2-when-looping-through/m-p/67090#M19695</link>
      <description>First you have to add a row in a collection to be append using ""Collection - add row"" and then use simple calculation stage to add values from one collection to another (i.e. collection2. = collection1.)
Using this method you can append a collection row by row</description>
      <pubDate>Mon, 10 Sep 2018 17:27:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Append-current-row-to-collection-2-when-looping-through/m-p/67090#M19695</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-09-10T17:27:00Z</dc:date>
    </item>
    <item>
      <title>That Logic makes great sense…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Append-current-row-to-collection-2-when-looping-through/m-p/67091#M19696</link>
      <description>That Logic makes great sense!
But when I try to add a row to Collection 2 (which is empty from the start), using the ""Collection - add row"" I then get this message:
Internal : The collection has no current row&amp;nbsp;</description>
      <pubDate>Mon, 10 Sep 2018 17:39:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Append-current-row-to-collection-2-when-looping-through/m-p/67091#M19696</guid>
      <dc:creator>stefan.hansen</dc:creator>
      <dc:date>2018-09-10T17:39:00Z</dc:date>
    </item>
    <item>
      <title>Anyone know why?</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Append-current-row-to-collection-2-when-looping-through/m-p/67092#M19697</link>
      <description>Anyone know why?</description>
      <pubDate>Tue, 11 Sep 2018 14:16:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Append-current-row-to-collection-2-when-looping-through/m-p/67092#M19697</guid>
      <dc:creator>stefan.hansen</dc:creator>
      <dc:date>2018-09-11T14:16:00Z</dc:date>
    </item>
    <item>
      <title>Hi there Stefan, 
Can you…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Append-current-row-to-collection-2-when-looping-through/m-p/67093#M19698</link>
      <description>Hi there Stefan,&amp;nbsp;
Can you provide an example?
Alternatively, can you provide the criteria for filtering your collection?
Josh</description>
      <pubDate>Tue, 11 Sep 2018 20:07:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Append-current-row-to-collection-2-when-looping-through/m-p/67093#M19698</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-09-11T20:07:00Z</dc:date>
    </item>
    <item>
      <title>Hi Stefan, 
You can use …</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Append-current-row-to-collection-2-when-looping-through/m-p/67094#M19699</link>
      <description>Hi Stefan,&amp;nbsp;
You can use&amp;nbsp;""Utility - Collection Manipulation - Append Rows to collection"", but need to do perform few things before.&amp;nbsp;
1. Create a variable of collection type - ""To copy row Collection""
2. Appned your selected row into this collection by calling the ""Collections - Copy Rows"",
- Input parameters: pass&amp;nbsp;your Collection 1, Start Row and End Row (in your case its always the same. Why? Because you want to copy only a single row).
- Out parameters: Use the ""To copy row collection"" created in step 1
3. Now use&amp;nbsp;""Utility - Collection Manipulation - Append Rows to collection"" with&amp;nbsp;
- input parameters: Collection 2 and ""To copy row Collection""
- out parameters : Collection 2
Let me know how it works out for you.
&amp;nbsp;
Thanks,
Joshi&amp;nbsp;</description>
      <pubDate>Wed, 12 Sep 2018 11:07:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Append-current-row-to-collection-2-when-looping-through/m-p/67094#M19699</guid>
      <dc:creator>Joshi_KumarA_V</dc:creator>
      <dc:date>2018-09-12T11:07:00Z</dc:date>
    </item>
    <item>
      <title>Thanks for the input.
I made…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Append-current-row-to-collection-2-when-looping-through/m-p/67095#M19700</link>
      <description>Thanks for the input.
I made it work by doing the following:
1. Add a row count when looping through Collection 1
2. Make a collection it copies the row to (it can't be collection 2 as it will remove the data already in there)
3. Use ""Collections - Copy Rows"" with input:&amp;nbsp;
&amp;nbsp;- Collection name: Collection 1
&amp;nbsp;- Start row: Row count
&amp;nbsp;- End row: Row count
Output:
&amp;nbsp;- Collection: Copied row
4. Use ""Utility - Collection manipulation - Append Rows to Collection"" with input:
&amp;nbsp;- Main collection: Collection 2
&amp;nbsp;- Collection to append: Copied row
Output:&amp;nbsp;
&amp;nbsp;- Combined Collection: Collection 2
&amp;nbsp;
&amp;nbsp;
I am pretty sure this is also what you mean joshikumarav.
Thanks for the help!</description>
      <pubDate>Wed, 12 Sep 2018 15:46:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Append-current-row-to-collection-2-when-looping-through/m-p/67095#M19700</guid>
      <dc:creator>stefan.hansen</dc:creator>
      <dc:date>2018-09-12T15:46:00Z</dc:date>
    </item>
  </channel>
</rss>

