Working with SQL Editor for building query (to create and retain links)
Can we perform queries to auto-populate a sheet when the source includes new rows while retaining the linking properties in the Destination?
Also, any idea on how to build queries to create links between two columns of a spreadsheet?
0
-
The first question can be solved by selecting a wider area for linking than necessary. So, e.g. your table goes up to column E, and you select up to column J.
The second question I don’t think I understand… are you asking about joining two different spreadsheets together? That would be done in a query, you'd add the spreadsheets as sources, then add the two columns in the relationships section.
0Please sign in to leave a comment.
Comments
1 comment