<?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 Delete multiple columns from collection in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Delete-multiple-columns-from-collection/m-p/73596#M26201</link>
    <description>Folks,

Is there any possible ways we can delete multiple columns at a time from collection?

If yes, Kindly notify please, and if it's possible from code please send code.

Thanks
Salman Ahmed</description>
    <pubDate>Wed, 03 Apr 2019 19:46:00 GMT</pubDate>
    <dc:creator>SalmanAhmed</dc:creator>
    <dc:date>2019-04-03T19:46:00Z</dc:date>
    <item>
      <title>Delete multiple columns from collection</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Delete-multiple-columns-from-collection/m-p/73596#M26201</link>
      <description>Folks,

Is there any possible ways we can delete multiple columns at a time from collection?

If yes, Kindly notify please, and if it's possible from code please send code.

Thanks
Salman Ahmed</description>
      <pubDate>Wed, 03 Apr 2019 19:46:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Delete-multiple-columns-from-collection/m-p/73596#M26201</guid>
      <dc:creator>SalmanAhmed</dc:creator>
      <dc:date>2019-04-03T19:46:00Z</dc:date>
    </item>
    <item>
      <title>Not enough info. You can…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Delete-multiple-columns-from-collection/m-p/73597#M26202</link>
      <description>Not enough info. You can just select() columns you need, if you know the field&amp;nbsp;names.

string[] selectedColumns = new[] { ""Column1"",""Column2""};
DataTable outDataTable= new DataView(inDataTable).ToTable(false, selectedColumns);.</description>
      <pubDate>Thu, 04 Apr 2019 11:21:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Delete-multiple-columns-from-collection/m-p/73597#M26202</guid>
      <dc:creator>AndreyKudinov</dc:creator>
      <dc:date>2019-04-04T11:21:00Z</dc:date>
    </item>
    <item>
      <title>Hi Salman,
 
You can just…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Delete-multiple-columns-from-collection/m-p/73598#M26203</link>
      <description>Hi Salman,
&amp;nbsp;
You can just create collection with these column names&amp;nbsp;in rows and then loop on in with delete action inside.
&amp;nbsp;
Best regards
Michal.</description>
      <pubDate>Thu, 04 Apr 2019 11:44:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Delete-multiple-columns-from-collection/m-p/73598#M26203</guid>
      <dc:creator>MichalSzumski</dc:creator>
      <dc:date>2019-04-04T11:44:00Z</dc:date>
    </item>
    <item>
      <title>Hi Salman,
This is my…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Delete-multiple-columns-from-collection/m-p/73599#M26204</link>
      <description>Hi Salman,
This is my solution using the&amp;nbsp;code stage( I don't know if there is an action that allow to delete multiple columns ):
The following code deletes all columns from the collection where the column header starts with ""Column""&amp;nbsp; but you can change the criteria to your needs&amp;nbsp;
BP_Collection_Out = BP_Collection_In
for count as Integer = (BP_Collection_Out.Columns.Count - 1) to 0 Step - 1
&amp;nbsp; &amp;nbsp; if BP_Collection_Out.Columns(count).ColumnName Like Deleting_Pattern&amp;nbsp;then
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; BP_Collection_Out.Columns.RemoveAt(count)
&amp;nbsp; &amp;nbsp; end if&amp;nbsp;
next
Inputs for&amp;nbsp;code stage:
BP_Collection_In: collection I want to delete the columns
Deleting_Pattern: Your criteria to delete columns
&amp;nbsp;
Outputs for code stage:
BP_Collection_Out
&amp;nbsp;
Hope this helps.</description>
      <pubDate>Fri, 05 Apr 2019 18:09:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Delete-multiple-columns-from-collection/m-p/73599#M26204</guid>
      <dc:creator>ErgesKokoshi</dc:creator>
      <dc:date>2019-04-05T18:09:00Z</dc:date>
    </item>
    <item>
      <title>Thank you all :)
 
 </title>
      <link>https://community.blueprism.com/t5/Product-Forum/Delete-multiple-columns-from-collection/m-p/73600#M26205</link>
      <description>Thank you all :)
&amp;nbsp;
&amp;nbsp;</description>
      <pubDate>Mon, 08 Apr 2019 18:03:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Delete-multiple-columns-from-collection/m-p/73600#M26205</guid>
      <dc:creator>SalmanAhmed</dc:creator>
      <dc:date>2019-04-08T18:03:00Z</dc:date>
    </item>
  </channel>
</rss>

