Hi there,
I have used the “Get Range Value” for sheets, to get all the numbers from a certain column. After running it I can click the module and see all the different outputs - but when I try to access them in a latter module, they do not show up. From searching the forum it looks to be something to do with the map/array functions, but I’m not sure how to apply it to this.
On this example I would like to access the numbers under “A”
Thanks
Hi @Rob5, What is the latter module where you’re trying to acces ‘A’ from ? from the looks of it you DO have access to it (last photo), just click on A ? For information, you won’t have access to earlier module outputs if they’re included in Aggregate type of modules. Is that your whole scenario?
Hi @kudracha, Thanks for the reply. I’m trying to access the numbers in a gmail module - I’m just experimenting connecting different modules and seeing how I can use the data.
I guess what I mean is - Usually the information I can access from a module is similar to the output I can see in the first image?
On the gmail module I can access “A” here which is the number from “Bundle 1: 0: 1” (essentially cell A2 has the number 1 in it) - but I was wondering how do I access the other numbers/outputs from the bundles?
@Rob5, Oh the gray thing? It’s just an example to let you know what type of data you can expect from this column. It just stays there until you make big changes on the module or data etc. Just a reference. To access other ‘numbers’, do you mean other columns? Just modify the range in ‘Get Range’ module.
how do I access the other numbers/outputs from the bundles?
Apart from columns you’ll have the spreadsheet ID and row number and stuff, as you can see they’re directly accessible. As you’ll adjust your range in the module you’ll see mroe columns (as long as they’re populated).
Ahh yeah I see what you mean on the grey part, makes sense.
Its not the columns i’m after - its the data stored in the rows A2:A7
So on the first image I have the rows A2:A7 and the outputs from them - Then on the second image, how can I access those outputs - ie. The numbers from A2:A7 — Do I have to map “A”?
Thanks again.
@Rob5, Yeah you just click on A and it references whatever value is in column ‘A’. For your information, ‘get range’ is iterating module. It means that you choose a range and it gets range row from row. Any other modules that come after this module are repeated ‘FOR EACH ROW’. Meaning, that mapped ‘A’ will become A2, A3, A4… depending on which row you are during the iteration. (you only need to click on A, nothing else).
Also, It looks like you haven’t declared A1 as a column header in ‘Get Range’ module, that’s why you’re seeing ‘A’ and not your column header name instead.
Thanks for the help! I added the header. Another thing I did was hover my mouse over the items in the array - This seemed to give me the actual name I needed when using the map function (for instance, Row Number: was “ROW_NUMBER”)
