I’m working with a dataset where I have a column ‘A’ that contains numbers ranging from 2 to 1016. In another column ‘B’, there’s associated text data for each number. I’m trying to use the Google Visualization API Query Language (Version 0.7) to pull data from column ‘B’ based on each individual number in column ‘A’.
Essentially, I want to run a query for number 2, then for number 3, and so on, until I reach 1016. I understand I can write individual queries like:
SELECT B WHERE A = 2 SELECT B WHERE A = 3 ...
However, I’m looking for a more dynamic solution where I don’t have to manually change the query each time. Is there a way to achieve this directly using the Query Language or perhaps an integrated solution with another tool or scripting language?
Any guidance or suggestions would be greatly appreciated!
Thank you in advance!