Datavault-UK / automate-dv

A free to use dbt package for creating and loading Data Vault 2.0 compliant Data Warehouses (powered by dbt, an open source data engineering tool, registered trademark of dbt Labs)
https://www.automate-dv.com
Apache License 2.0
514 stars 131 forks source link

[FEATURE] Allow composite derived columns via a list #20

Closed DVAlexHiggs closed 3 years ago

DVAlexHiggs commented 3 years ago

Allow a list to be provided to derived columns like so:

derived_columns:
  CUSTOMER_NK: 
    - CUSTOMER_NAME
    - CUSTOMER_ID

Given CUSTOMER_NAME = "Alex" And CUSTOMER_ID = 001 Then CUSTOMER_NK: = Alex||001

In future we will provide a means to configure the concatenation string, but for now the double pipe standard will be used.

This will allow concatenated values to be generated for situations where one column is not enough to define a required value.

This was suggested in #9 and is defined here as a separate feature for trackability.