<?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 Columns with the same heading in a collection in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Columns-with-the-same-heading-in-a-collection/m-p/87785#M38448</link>
    <description>Hi all

Please can you help me with the best way of overcoming this system exception - 'A column named 'Normal' already belongs to the DataTable'

I can't hardcode the column headers in to the collection as it varies from account to account. Some accounts could have just one header named 'Normal' whist another account might have 2 headers named 'Normal'.

I export the data to Excel (they'll be 4 to 6 columns of data, occasionally with a duplicate column named Normal as described above) then import the Excel sheet in to a collection.

Thanks in advance

Jordan</description>
    <pubDate>Mon, 15 Oct 2018 18:20:00 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2018-10-15T18:20:00Z</dc:date>
    <item>
      <title>Columns with the same heading in a collection</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Columns-with-the-same-heading-in-a-collection/m-p/87785#M38448</link>
      <description>Hi all

Please can you help me with the best way of overcoming this system exception - 'A column named 'Normal' already belongs to the DataTable'

I can't hardcode the column headers in to the collection as it varies from account to account. Some accounts could have just one header named 'Normal' whist another account might have 2 headers named 'Normal'.

I export the data to Excel (they'll be 4 to 6 columns of data, occasionally with a duplicate column named Normal as described above) then import the Excel sheet in to a collection.

Thanks in advance

Jordan</description>
      <pubDate>Mon, 15 Oct 2018 18:20:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Columns-with-the-same-heading-in-a-collection/m-p/87785#M38448</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-10-15T18:20:00Z</dc:date>
    </item>
    <item>
      <title>You will have to rename one…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Columns-with-the-same-heading-in-a-collection/m-p/87786#M38449</link>
      <description>You will have to rename one&amp;nbsp;column somewhere. It depends on actual process details -&amp;nbsp;one or two columns always called ""Normal"" would have a&amp;nbsp;simple solution, arbitrary number of duplicate columns with unknown names is a completely different case.
For example, find&amp;nbsp;Normal in headers in excel and rename to Normal1, Normal2 ...
&amp;nbsp;</description>
      <pubDate>Mon, 15 Oct 2018 19:06:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Columns-with-the-same-heading-in-a-collection/m-p/87786#M38449</guid>
      <dc:creator>AndreyKudinov</dc:creator>
      <dc:date>2018-10-15T19:06:00Z</dc:date>
    </item>
  </channel>
</rss>

