Skip to main content
V
Most Valuable Pathfinder
Vern DicksonMost Valuable Pathfinder
Most Valuable Pathfinder
March 6, 2025
Solved

Unknown error assigning a value to a column in a data table

  • March 6, 2025
  • 3 replies
  • 202 views

I am trying to assign 74 character string variable to the first column in a data table and I am getting this error: An unknown error occurred while trying to assign value "This is a test comment to be split to see how it will break comments in to" to the table at row index "0.0" and column index "0". I have added the row and I am using the correct index for the row and column, Any ideas on how to correct this?

      This topic has been closed for replies.
      Best answer by Vern Dickson

      OK, I finally figured it out.  On the record variable for the table you have to define the columns:

      Record Variable

       

      On the table itself you just have specify the number of columns:

      Table Variable

      Once I got the variables in sync it started working. Thanks for everyone’s suggestions. 

      3 replies

      Lu.Hunnicutt
      Pathfinder Community Team
      Lu.Hunnicutt
      Pathfinder Community Team
      March 6, 2025

      Hi ​@Vern Dickson Let me tag a few folks that may be able to help you with this.

      ​@Shreya.Kumar 

      ​@Marc 1985 

      ​@LoganPrice 

      Let's Connect! www.linkedin.com/in/lu-hunnicutt-1290jan
        Marc Mueller
        Most Valuable Pathfinder
        Marc MuellerMost Valuable Pathfinder
        Most Valuable Pathfinder
        March 6, 2025

        Hi ​@Vern Dickson,

        have you tried to use the column "Header" instead of the index?

         

        By the way: Row index 0.0 should just be index 0 🤔 (integer not a decimal)

         

        If you used the 'Set value of a single cell' action see below.

        https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/data-table-package-set-value-sinlge-cell-action.html

         

        Or put a screenshot of your lines of code for me please 😊

         

        Cheers

        Marc

        🤝Let's connect on LinkedIn: https://www.linkedin.com/in/developer-marc-mueller >>>>>>>> 📺Check out my YouTube channel - https://youtube.com/@AutomationDevelopmentEasy
          V
          Most Valuable Pathfinder
          Vern DicksonMost Valuable PathfinderAuthorAnswer
          Most Valuable Pathfinder
          March 6, 2025

          OK, I finally figured it out.  On the record variable for the table you have to define the columns:

          Record Variable

           

          On the table itself you just have specify the number of columns:

          Table Variable

          Once I got the variables in sync it started working. Thanks for everyone’s suggestions. 

            Terms & ConditionsAccessibility statement