<?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 Collection Query - deleting multiple columns in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Collection-Query-deleting-multiple-columns/m-p/47328#M3097</link>
    <description>Hi,

I've added an Excel sheet as a collection and have been successful in deleting one undesired column using the Collection utility. Would somebody be able to give me some pointers on how I could use a multiline expression to delete several columns? Is it possible?

e.g. I want to delete "Address Line 1" &amp;amp; "Address Line 2" &amp;amp; "Address Line 3" from the collection what would the correct syntax be in the expression editor?

Thanks</description>
    <pubDate>Mon, 17 Jul 2017 18:30:00 GMT</pubDate>
    <dc:creator>JamesWilliams</dc:creator>
    <dc:date>2017-07-17T18:30:00Z</dc:date>
    <item>
      <title>Collection Query - deleting multiple columns</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Collection-Query-deleting-multiple-columns/m-p/47328#M3097</link>
      <description>Hi,

I've added an Excel sheet as a collection and have been successful in deleting one undesired column using the Collection utility. Would somebody be able to give me some pointers on how I could use a multiline expression to delete several columns? Is it possible?

e.g. I want to delete "Address Line 1" &amp;amp; "Address Line 2" &amp;amp; "Address Line 3" from the collection what would the correct syntax be in the expression editor?

Thanks</description>
      <pubDate>Mon, 17 Jul 2017 18:30:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Collection-Query-deleting-multiple-columns/m-p/47328#M3097</guid>
      <dc:creator>JamesWilliams</dc:creator>
      <dc:date>2017-07-17T18:30:00Z</dc:date>
    </item>
    <item>
      <title>It's not possible with the</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Collection-Query-deleting-multiple-columns/m-p/47329#M3098</link>
      <description>It's not possible with the current utility object, but it is possible to write more .Net code to do that. However, it would be quicker just o call the utility3 times.</description>
      <pubDate>Mon, 17 Jul 2017 19:27:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Collection-Query-deleting-multiple-columns/m-p/47329#M3098</guid>
      <dc:creator>John__Carter</dc:creator>
      <dc:date>2017-07-17T19:27:00Z</dc:date>
    </item>
  </channel>
</rss>

