• 23 October 2017
  • 1 reply

can one view pull columns from a derived table and a real table?

1 reply

Userlevel 2

Hi Sebastian,

Thanks for reaching out. The good news is yes, you can ‘pull’ columns from an existing view or PDT.

To achieve this while writing either a dimension or a measure you can reference view_name.field_name as per this discourse

If you want to reference an entire view you can use include: view_name in the model file.

Alternatively you can use the extends parameter to extend a view.

This discourse explains how this process works and what prior knowledge you will need for this process.