Retrieving a dynamic range with Retrieve Data Module in a table

How To
1

Hi There, trying to retrieve a dynamic range from a table based on a certain counter (or rownumber) from a table. I don’t seem to get syntax right.
trying ot solve it with: (A{{1+counter}}:I{{17+counter}}), but no luck yet.

Kind regards,

Bas

image
image465×771 42.6 KB

2

Welcome to the Make community!

To perform Math operations on numerical values, you need to use the parseNumber function

e.g.:

{{parseNumber(1)+1.counter}}

A{{(parseNumber(1) + 1.counter)}}:I{{(parseNumber(17) + 1.counter)}}

Screenshot_2025-02-27_160229

For more information, see the parseNumber function documentation in the Help Center and do the tutorials in the Make Academy.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

3

Thanks Sam, I solved it by creating the range as a string before this module and import. That seem to work. I tried your approach, but somehow it was calling it an incorrect array. Anyway, it works. Thanks!

2 Likes