Pentaho

 View Only

 Pentaho Metadata Editor - How to define formula for a Business column which refers to columns from two tables?

Kshitija Marathe's profile image
Kshitija Marathe posted 05-06-2024 02:26

Hello Pentaho Team,

I looked at the below doc:

https://docs.hitachivantara.com/r/en-us/pentaho-data-integration-and-analytics/10.1.x/mk-95pdia007/pentaho-metadata-formulas/second-use-physical-table-column-formulas

Here it is mentioned that we can refer business columns from two different Business tables and define formula for Business Column (Calculated field) But unable to make it work. Can you please help with the correct example with exact steps to be followed to achieve this?

Appreciate your quick help on this please.

Thanks & Regards,

Kshitija Marathe