<?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 Thanks for your reply John in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/quot-Go-to-column-in-one-row-collection-after-get-next-item-quot/m-p/70211#M22816</link>
    <description>Thanks for your reply John but I think this is not what I am looking for... I need to calculate how many fields nex to Column1 I will go to, so Data.Column5 is + 4 fields from Data.Column1, Data.Column9 is +4 fields from Data.Column5 and so on. Is there a way to calculate this in loop?</description>
    <pubDate>Wed, 18 Oct 2017 14:00:00 GMT</pubDate>
    <dc:creator>RadovanBordovsk</dc:creator>
    <dc:date>2017-10-18T14:00:00Z</dc:date>
    <item>
      <title>"Go to column in one row collection after get next item"</title>
      <link>https://community.blueprism.com/t5/Product-Forum/quot-Go-to-column-in-one-row-collection-after-get-next-item-quot/m-p/70209#M22814</link>
      <description>Hello,

Is there a way to specifically tell the BP to go to cell named e.g. "Data.Column5" by calculating "5" in calculation stage. So I mean to separate the "Data.Column" and "5" so "5" can be calculated by some loop and then it would end up together in e.g. data item as "Data.Column5".
Is it understandable?
Could you please advise on this?

Thank you very much

R.</description>
      <pubDate>Wed, 18 Oct 2017 13:45:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/quot-Go-to-column-in-one-row-collection-after-get-next-item-quot/m-p/70209#M22814</guid>
      <dc:creator>RadovanBordovsk</dc:creator>
      <dc:date>2017-10-18T13:45:00Z</dc:date>
    </item>
    <item>
      <title>Utility - Collection</title>
      <link>https://community.blueprism.com/t5/Product-Forum/quot-Go-to-column-in-one-row-collection-after-get-next-item-quot/m-p/70210#M22815</link>
      <description>Utility - Collection Manipulation.Read Collection Field</description>
      <pubDate>Wed, 18 Oct 2017 13:49:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/quot-Go-to-column-in-one-row-collection-after-get-next-item-quot/m-p/70210#M22815</guid>
      <dc:creator>John__Carter</dc:creator>
      <dc:date>2017-10-18T13:49:00Z</dc:date>
    </item>
    <item>
      <title>Thanks for your reply John</title>
      <link>https://community.blueprism.com/t5/Product-Forum/quot-Go-to-column-in-one-row-collection-after-get-next-item-quot/m-p/70211#M22816</link>
      <description>Thanks for your reply John but I think this is not what I am looking for... I need to calculate how many fields nex to Column1 I will go to, so Data.Column5 is + 4 fields from Data.Column1, Data.Column9 is +4 fields from Data.Column5 and so on. Is there a way to calculate this in loop?</description>
      <pubDate>Wed, 18 Oct 2017 14:00:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/quot-Go-to-column-in-one-row-collection-after-get-next-item-quot/m-p/70211#M22816</guid>
      <dc:creator>RadovanBordovsk</dc:creator>
      <dc:date>2017-10-18T14:00:00Z</dc:date>
    </item>
    <item>
      <title>Utility - Collection</title>
      <link>https://community.blueprism.com/t5/Product-Forum/quot-Go-to-column-in-one-row-collection-after-get-next-item-quot/m-p/70212#M22817</link>
      <description>Utility - Collection Manipulation.Read Collection Field and loop
Utility - Collection Manipulation.Read Collection Field
 Loop
     If([Field]) = Column from - Set a Data Item to the [Count] (Count1)
     If([Field]) = Column To - Set a Data Item to the [Count] (Count2)
     [Count]+1
 Loop_End
(Count2) - (Count1) = What you want?</description>
      <pubDate>Wed, 18 Oct 2017 17:16:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/quot-Go-to-column-in-one-row-collection-after-get-next-item-quot/m-p/70212#M22817</guid>
      <dc:creator>Christer_Tellefsen</dc:creator>
      <dc:date>2017-10-18T17:16:00Z</dc:date>
    </item>
    <item>
      <title>Thanks Christer. that is the</title>
      <link>https://community.blueprism.com/t5/Product-Forum/quot-Go-to-column-in-one-row-collection-after-get-next-item-quot/m-p/70213#M22818</link>
      <description>Thanks Christer. that is the kind thing I was thinking about.
Radek - how about Utility - Collection Manipulation.Get Collection Fields? This gives you the names of the files in a collection which you could loop through.</description>
      <pubDate>Thu, 19 Oct 2017 12:32:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/quot-Go-to-column-in-one-row-collection-after-get-next-item-quot/m-p/70213#M22818</guid>
      <dc:creator>John__Carter</dc:creator>
      <dc:date>2017-10-19T12:32:00Z</dc:date>
    </item>
  </channel>
</rss>

