|
Klassiske filtyper er ikke lenger tilgjengelige for bruk fra og med januar 2021. Du kan overføre klassiske filer eller laste ned en PDF-fil. Finn ut mer

Working with SQL Editor for building query (to create and retain links)

Be om demo

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

Kommentarer

1 kommentar

Dato Stemmer
  • Permanently deleted user

    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.

    0

Logg på for å legge inn en kommentar.