<?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 I use this code to remove… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Delete-null-columns/m-p/85985#M36912</link>
    <description>I use this code to remove null columns:

Dim Changed As Boolean = False
Do
&amp;nbsp;Changed = False
&amp;nbsp;For Each Column As DataColumn In Input_Collection.Columns
&amp;nbsp;&amp;nbsp; &amp;nbsp;Dim removeColumn as Boolean = True
&amp;nbsp;&amp;nbsp; &amp;nbsp;For Each row As DataRow In Input_Collection.Rows
&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;If (Not (row(Column) = """")) Then
&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;removeColumn = False
&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;Exit For&amp;nbsp;&amp;nbsp; &amp;nbsp;
&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;End IF
&amp;nbsp;&amp;nbsp; &amp;nbsp;Next
&amp;nbsp;&amp;nbsp; &amp;nbsp;If (removeColumn) Then&amp;nbsp;
&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;Input_Collection.Columns.Remove(Column)
&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;Changed = True
&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;Exit For
&amp;nbsp;&amp;nbsp; &amp;nbsp;End If
&amp;nbsp;Next
Loop while Changed = True
Output_Collection = Input_Collection</description>
    <pubDate>Mon, 30 Jul 2018 13:08:00 GMT</pubDate>
    <dc:creator>AndreyKudinov</dc:creator>
    <dc:date>2018-07-30T13:08:00Z</dc:date>
    <item>
      <title>Delete null columns</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Delete-null-columns/m-p/85981#M36908</link>
      <description>Is there any vbo to delete empty columns as we have for rows, or if there is any code to use?</description>
      <pubDate>Tue, 24 Jul 2018 18:44:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Delete-null-columns/m-p/85981#M36908</guid>
      <dc:creator>Karan_</dc:creator>
      <dc:date>2018-07-24T18:44:00Z</dc:date>
    </item>
    <item>
      <title>Yes the Utility - Collection…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Delete-null-columns/m-p/85982#M36909</link>
      <description>Yes the Utility - Collection Manipulation VBO</description>
      <pubDate>Tue, 24 Jul 2018 21:14:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Delete-null-columns/m-p/85982#M36909</guid>
      <dc:creator>John__Carter</dc:creator>
      <dc:date>2018-07-24T21:14:00Z</dc:date>
    </item>
    <item>
      <title>Thanks John, but there I…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Delete-null-columns/m-p/85983#M36910</link>
      <description>Thanks John, but there I could find only for rows. I am looking for something to delete empty columns.</description>
      <pubDate>Tue, 24 Jul 2018 22:49:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Delete-null-columns/m-p/85983#M36910</guid>
      <dc:creator>Karan_</dc:creator>
      <dc:date>2018-07-24T22:49:00Z</dc:date>
    </item>
    <item>
      <title>Hi Karan,
I don't think…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Delete-null-columns/m-p/85984#M36911</link>
      <description>Hi Karan,
I don't think BluePrism has any standard objects for deleting empty columns. You would either have to write a code for this, or use an alternative method to do so.
For the alternative method, you can try the following:
Let's say you want to remove empty columns from Collection A.
First, use 'Get Collection Fields' on Collection A. The list of column names will be output into Collection B.
Loop through Collection B column names.
For each column, filter Collection A by non-blank values, into Collection C. You can input ""[""&amp;amp;[Collection B.Field Name]&amp;amp;""]''"" into the filter input (i.e. [Column Name]'').
Count the number of rows in the filtered Collection C.
If count &amp;gt; 0, don't delete the column. If count = 0, delete the column.</description>
      <pubDate>Fri, 27 Jul 2018 14:42:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Delete-null-columns/m-p/85984#M36911</guid>
      <dc:creator>BellaKoh</dc:creator>
      <dc:date>2018-07-27T14:42:00Z</dc:date>
    </item>
    <item>
      <title>I use this code to remove…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Delete-null-columns/m-p/85985#M36912</link>
      <description>I use this code to remove null columns:

Dim Changed As Boolean = False
Do
&amp;nbsp;Changed = False
&amp;nbsp;For Each Column As DataColumn In Input_Collection.Columns
&amp;nbsp;&amp;nbsp; &amp;nbsp;Dim removeColumn as Boolean = True
&amp;nbsp;&amp;nbsp; &amp;nbsp;For Each row As DataRow In Input_Collection.Rows
&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;If (Not (row(Column) = """")) Then
&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;removeColumn = False
&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;Exit For&amp;nbsp;&amp;nbsp; &amp;nbsp;
&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;End IF
&amp;nbsp;&amp;nbsp; &amp;nbsp;Next
&amp;nbsp;&amp;nbsp; &amp;nbsp;If (removeColumn) Then&amp;nbsp;
&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;Input_Collection.Columns.Remove(Column)
&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;Changed = True
&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;Exit For
&amp;nbsp;&amp;nbsp; &amp;nbsp;End If
&amp;nbsp;Next
Loop while Changed = True
Output_Collection = Input_Collection</description>
      <pubDate>Mon, 30 Jul 2018 13:08:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Delete-null-columns/m-p/85985#M36912</guid>
      <dc:creator>AndreyKudinov</dc:creator>
      <dc:date>2018-07-30T13:08:00Z</dc:date>
    </item>
  </channel>
</rss>

