If there is only one column of data in Excel, when we try to assign it to a Record variable using a loop action, an error will occur and it will stop working. Why?
About single-column record variables
Hi
Can you please share the screen shot of the code.
If there is only one column of data in Excel, when we try to assign it to a Record variable using a loop action, an error will occur and it will stop working. Why?
Can you please share the screenshot of the issue.
![Collaborator Badge](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/eeb1807e-43ef-49be-9d57-ee7e35651ddc_thumb.png)
Error screen and Excel data.
Error screen and Excel data.
Request you to please share the screenshot of your logic where you are accessing the excel data using record variable as I am able to access each row using record variable inside the excel loop.
Please check the below screenshot of first iteration output using record variable.
![](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/a94c9590-b895-44d3-ac48-af900380303e.png)
![Collaborator Badge](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/eeb1807e-43ef-49be-9d57-ee7e35651ddc_thumb.png)
As I simply used record to store each row in the loop and using → record[0], I was able to extract the values row by row present in first column. Please refer below screenshot.
![](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/a284137d-1b9a-4888-8548-290327af5595.png)
![](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/956c1410-4f93-46bb-bdf2-cd3869d6ad0f.png)
![Collaborator Badge](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/eeb1807e-43ef-49be-9d57-ee7e35651ddc_thumb.png)
The counter is simply set up to count the number of data. (Count the number of pieces of data that match the value entered in the prompt)
I'm trying both a record variable and multiple variables, but I get the same error.
Screenshot of a record variable.
In the first place, stop at Line 2. :(
The counter is simply set up to count the number of data. (Count the number of pieces of data that match the value entered in the prompt)
I'm trying both a record variable and multiple variables, but I get the same error.
Screenshot of a record variable.
In the first place, stop at Line 2. :(
![](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/8863d3dd-4419-4548-a036-b907146bb62d.png)
![Collaborator Badge](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/eeb1807e-43ef-49be-9d57-ee7e35651ddc_thumb.png)
Thank you! Resolution. This data does not require a header. I really appreciate your help.Thank you very much for your kindness!!
Thank you! Resolution. This data does not require a header. I really appreciate your help.Thank you very much for your kindness!!
No issues !
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.