Rucal-Data-Solutions / datalakefoundation

Datalakehouse Foundation
GNU General Public License v3.0
3 stars 0 forks source link

Calculated columns #13

Closed Gateway1024 closed 8 months ago

Gateway1024 commented 8 months ago

I want to be able to create calculated columns.

With this feature I can add a column that contains minor row based logic

Example: I have a accounting system with multiple administrations each in a separate database and although the schema is consistent across these databases the row number is ambiguous. with the merge function I could theoretically merge all these databases together but the business keys are the same and will overwrite the other records