Calculated Column (using SQL -Mixing Tables in Data Foundation or Business Layer)

[former_member573008]

1. Hi Guys, I need to create a calculated column at detail level table, but I need to ask for a specific column in table header in order to get a value (master, detail). Both tables are linked by a primary key. I don't know how to do it in data foundation or business layer. Please any example is much appreciated.

Regards,

Iv.

[former_member573008]

Hi Joe, much appreciated for your feedback. Any example that could help me.

Regards,

Iv.

[Joe_Peters]

Calculated columns are strictly tied to a single table. You can either create a derived table that combines both, and include the calculation there, or do what we used to do in UDT: Create a regular object in the BL that does the calculation, and then reference its definition in other objects by using @Select().