Create an Excel template with datas from another book

Note: If needed, see how to create a simple Excel template.

Export data from a linked table

To export data from a linked table, add one. (dot) column name followed by the column name of the desired linked table:

NAME_OF_THE_COLUMN.NAME_COLUMN_TABLE_LINKED_CHOSEN

If exporting a linked column to another table has more than one data, there will be as many rows created in the export as there are data.

Example : 

In the table I want to export, my client has three invoices that correspond to data linked to another table.

In my model, I create only one line for the data corresponding to Invoice:

Example:

When I use my model for export, I have the corresponding lines to the data linked to another table that are created automatically:

Examples to download

Template

Export example