Getting relation entry by index

I have a table with nautical information data for each day of the year. The left column is the date and then there are about 30 different columns of distinct data for each day.

I can create a relation based on date that returns a specific row of the table. To get the data of a column in that row, I’ve been creating lookups for each column against the relation and then making an array from those columns and selecting an index of the array, is there a way to just get the nth element of the relation?

cheers,

JB

You could put the Make Array in the other table, and then you only need one Lookup column.

The other table meaning the table with the data itself? Can I do that if it’s a Google sheet?

Yes, the table with your dates and other data.

Yes you can definitely add computed columns to any table, even one sourced from a google sheet.

Not sure I’m following the Make Array suggestion. In the data table rows (dates), columns (data), adding a Make Array asks me to select a column and then for that column adds all the dates. I’d have to do that for each and every column. Sort of the same as a look for each and every column. Is there a way to just index into the relation? It’s really easy for me to calculate the row in the relation (the column in the data table) that I need.

No you can’t index the relation unfortunately, but didn’t you say that you created an array from all your Lookup columns? Wouldn’t it be the same process, but make that array in your dates table instead of the table where you had the relation and lookups?

1 Like