I have a necessary query column in a table. Each row of that column contains a list that is the results of the query. Is it possible to use a single value column/from start and index directly into that list? I want to treat it as if it were an array. I couldn’t seem to make it work and I don’t think you can easily convert it into an array with Make Array. If I could do that it would tremendously simplify my code.
Yes, that should work as long as the Query is not targeting a Big Table. Only Single Value->First is supported with Big Tables.
If you can’t get it to work, share some screen shots and we should be able to help.
Thanks. Will do in the am. I’m too tired to think right now in my time zone.
The pic below is the data table I am querying.
I need to extract groups of data, 3 rows at a time and 3 columns at time for a table to be displayed. My query uses the 3 left columns - idx, date, speed.
In a separate table I look up the index (idx), the date and the speed and execute my query.
I then create arrays of the relevant groups of 3 columns for display later.
Rather than creating all those intermediate columns and arrays, I’d like to just use a single value column created directly from the query.
The query has everything I need and I can index into the data to extract the correct 3 columns.
But when I try to create a single value column, I can’t figure out how to choose the query column itself. It doesn’t seem to be available. I tried using the query column > whole row selection but it doesn’t create anything useful.
All help appreciated.
I posted screenshots. Not working
Not sure if I’m missing something, but wouldn’t you want a separate single value column for each of CCC Start, CCC Best and CCC End?
If you wanted to return the values for all three rows at once, then you probably want a joined list through each query.
I’m not really clear what the end result should look like, though. Can you elaborate on that part?
1 Like
For each location CCC, CDC, ER, etc, I want to display 3 columns and 3 rows. For each row in the query, I have all the data I need for the 3 columns and I always know the offset (index) into the list of the query. For the query row shown in the example, I would just need a single value starting at index 9 for ER or 6 for CDC. I was hoping to get rid of the need for 27 columns (3 for each of 9 locations) and reduce it to just two by using an index into the query result. Now I’m not sure if it’s simpler, but I still don’t think you can create a single value column directly from the query result. There is no way to select it as a column.
That is correct. This data is calculated outside of glide and uploaded as a large google sheet. There are 9 locations, 3 columns each, with 3 rows for every day of the year. It’s from this table I build the display table component.
Sorry, 9 locations, 3 columns (start, best, end), 3 rows for everyday day of the year for each of 8 speeds - 3 thru 10 kts. The image above shows the display processing table where I have a query that finds a match for the date, speed and row (1,2,3). The result is columns for each of the 3 location times (start, best, end) for each location. I then build an array of all the starts for that date, idx, speed, an array for all the bests, and an array for all the ends. I can then make sv columns with an index into the arrays so that I get, for example the 3rd value from each array - starts(3) = ER start, bests(3) = ER best, ends(3) = ER end. I show it in the image above called arc data 2.