can one view pull columns from a derived table and a real table?
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
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_nameas per this discourse
If you want to reference an entire view you can use
include: view_namein 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.