Skip to main content
Cadet | Tier 2
January 25, 2024
Solved

About single-column record variables

  • January 25, 2024
  • 11 replies
  • 365 views
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?
Best answer by Zaid Chougle

 

@Zaid Chougle

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. :(

@YKare2023  As there is an error on Line 2 i.e. excel open, can you please open it with unchecking Sheet contains header and also remove the sheet name. Refer below screenshot.

 

 

11 replies

Zaid Chougle
Navigator | Tier 3
Navigator | Tier 3
January 30, 2024

@YKare2023, please mark the solution in the thread if your issue was resolved.

Lets Automate !