<?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 Issue while reading the Table column data &amp;amp; Auto calculate field error in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Issue-while-reading-the-Table-column-data-amp-Auto-calculate/m-p/125747#M54638</link>
    <description>&lt;P&gt;Hi All,&lt;BR /&gt;I am using Decipher2.3&lt;BR /&gt;We are trying to read the table column value as is, but sometimes it populates&lt;BR /&gt;&amp;gt;empty value&lt;BR /&gt;&amp;gt;only first line/Sec line value of same row&lt;BR /&gt;&amp;gt;Correct value&lt;BR /&gt;&amp;gt;Sometimes it ignores to read the complete row.&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial black,avant garde"&gt;&lt;STRONG&gt;Issue1:&lt;/STRONG&gt;&lt;/FONT&gt;&lt;BR /&gt;&amp;nbsp;while reading a column value (Assume column name as Product num) in the table data.&lt;BR /&gt;Scenario1: Where the line has expected value Can be numeric or alphanumeric (Single line or two lines with additional data in the same row)&lt;BR /&gt;Scenario2: Empty value. Expected outcome of ocr is NULL to be populated.&lt;BR /&gt;Scenario3: Random text.&lt;BR /&gt;&amp;gt;We have trained the DFD with almost 300+ documents with all the above scenarios as individual and mixed batches.&lt;BR /&gt;&amp;gt;As the column value is important for business logic validation whether to continue or stop processing the main Queue item.&lt;BR /&gt;&lt;FONT face="arial black,avant garde"&gt;Note&lt;/FONT&gt;: Updated the Misc. parameters UTD=true.&lt;BR /&gt;It populated the correct value sometimes but in a batch of 10 doc if 3 are exception with this issue and 3 are with other issue then the automation rate is very low So considering this i am posting.&lt;BR /&gt;&amp;gt;We cannot use ant regex/formulas as its important to read whatever the value it has even if its empty.&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;&lt;STRONG&gt;&lt;FONT face="arial black,avant garde"&gt;Issue2&lt;/FONT&gt;:&lt;/STRONG&gt;&lt;/EM&gt;&lt;BR /&gt;We have created an extra field inside the table fields with auto calculate function to define a value based on the another field, But the formula works only for the first row as for all the remaining rows it copies the first row value.&lt;BR /&gt;Eg: as per the formula, first row value is x and t populates the correct value but all the rows from 2 to n is populated with same first row value which is x.&lt;BR /&gt;Any solution or am i missing anything here. Please suggest.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kiranb25_0-1782147530469.png" style="width: 400px;"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/42246i696562626F3A6AD3/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="kiranb25_0-1782147530469.png" alt="kiranb25_0-1782147530469.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/15488"&gt;@Ben.Lyons1&lt;/a&gt;&amp;nbsp;Could you please suggest any solution for the above or am i missing anything is dfd?&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;P&gt;Thanks,&lt;BR /&gt;Kiran&lt;/P&gt;</description>
    <pubDate>Mon, 22 Jun 2026 17:09:09 GMT</pubDate>
    <dc:creator>kiranb25</dc:creator>
    <dc:date>2026-06-22T17:09:09Z</dc:date>
    <item>
      <title>Issue while reading the Table column data &amp; Auto calculate field error</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Issue-while-reading-the-Table-column-data-amp-Auto-calculate/m-p/125747#M54638</link>
      <description>&lt;P&gt;Hi All,&lt;BR /&gt;I am using Decipher2.3&lt;BR /&gt;We are trying to read the table column value as is, but sometimes it populates&lt;BR /&gt;&amp;gt;empty value&lt;BR /&gt;&amp;gt;only first line/Sec line value of same row&lt;BR /&gt;&amp;gt;Correct value&lt;BR /&gt;&amp;gt;Sometimes it ignores to read the complete row.&lt;/P&gt;&lt;P&gt;&lt;FONT face="arial black,avant garde"&gt;&lt;STRONG&gt;Issue1:&lt;/STRONG&gt;&lt;/FONT&gt;&lt;BR /&gt;&amp;nbsp;while reading a column value (Assume column name as Product num) in the table data.&lt;BR /&gt;Scenario1: Where the line has expected value Can be numeric or alphanumeric (Single line or two lines with additional data in the same row)&lt;BR /&gt;Scenario2: Empty value. Expected outcome of ocr is NULL to be populated.&lt;BR /&gt;Scenario3: Random text.&lt;BR /&gt;&amp;gt;We have trained the DFD with almost 300+ documents with all the above scenarios as individual and mixed batches.&lt;BR /&gt;&amp;gt;As the column value is important for business logic validation whether to continue or stop processing the main Queue item.&lt;BR /&gt;&lt;FONT face="arial black,avant garde"&gt;Note&lt;/FONT&gt;: Updated the Misc. parameters UTD=true.&lt;BR /&gt;It populated the correct value sometimes but in a batch of 10 doc if 3 are exception with this issue and 3 are with other issue then the automation rate is very low So considering this i am posting.&lt;BR /&gt;&amp;gt;We cannot use ant regex/formulas as its important to read whatever the value it has even if its empty.&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;P&gt;&lt;EM&gt;&lt;STRONG&gt;&lt;FONT face="arial black,avant garde"&gt;Issue2&lt;/FONT&gt;:&lt;/STRONG&gt;&lt;/EM&gt;&lt;BR /&gt;We have created an extra field inside the table fields with auto calculate function to define a value based on the another field, But the formula works only for the first row as for all the remaining rows it copies the first row value.&lt;BR /&gt;Eg: as per the formula, first row value is x and t populates the correct value but all the rows from 2 to n is populated with same first row value which is x.&lt;BR /&gt;Any solution or am i missing anything here. Please suggest.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kiranb25_0-1782147530469.png" style="width: 400px;"&gt;&lt;img src="https://community.blueprism.com/t5/image/serverpage/image-id/42246i696562626F3A6AD3/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="kiranb25_0-1782147530469.png" alt="kiranb25_0-1782147530469.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&lt;a href="https://community.blueprism.com/t5/user/viewprofilepage/user-id/15488"&gt;@Ben.Lyons1&lt;/a&gt;&amp;nbsp;Could you please suggest any solution for the above or am i missing anything is dfd?&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;P&gt;Thanks,&lt;BR /&gt;Kiran&lt;/P&gt;</description>
      <pubDate>Mon, 22 Jun 2026 17:09:09 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Issue-while-reading-the-Table-column-data-amp-Auto-calculate/m-p/125747#M54638</guid>
      <dc:creator>kiranb25</dc:creator>
      <dc:date>2026-06-22T17:09:09Z</dc:date>
    </item>
    <item>
      <title>Re: Issue while reading the Table column data &amp; Auto calculate field error</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Issue-while-reading-the-Table-column-data-amp-Auto-calculate/m-p/125759#M54641</link>
      <description>&lt;P&gt;Hi Kiran,&lt;/P&gt;&lt;P&gt;I'm not sure about your first issue, it's difficult without the DFD, seeing the document and having the full details of your training. I would recommend raising a support ticket and if you can share these details, we might be able to provide some guidance.&lt;/P&gt;&lt;P&gt;The second issue is lightly due to the missing parametric variable. For formulas in a table to applied to each row, you need to include #. The # will be automatically replaced with the row number e.g.&amp;nbsp;&lt;SPAN&gt;FT_LINE_TOTAL:# - FT_LINE_DISCOUNT:# + 1000. See the respective section on Parametric Variables in the online help&amp;nbsp;&lt;A href="https://documentation.blueprism.com/decipher-2-4/en-us/user-guide/formula-language.htm?tocpath=Interface%7CAdmin%20panel%7CDocument%20form%20definitions%7C_____4#Variables" target="_blank"&gt;Formula language&lt;/A&gt;.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Thanks&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;Ben&lt;/P&gt;</description>
      <pubDate>Wed, 24 Jun 2026 07:28:27 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Issue-while-reading-the-Table-column-data-amp-Auto-calculate/m-p/125759#M54641</guid>
      <dc:creator>Ben.Lyons1</dc:creator>
      <dc:date>2026-06-24T07:28:27Z</dc:date>
    </item>
  </channel>
</rss>

