Skip to Content
0

Calculated Column Data Foundation (Using SQL)

May 16 at 03:21 PM

13

avatar image
Former Member

Hi Guys, I need to create a calculated column at data foundation in IDT. Can I use sql statement?. I mean mix two tables to reach my requirement. If so, have you any example to see the syntax ?. Much appreciated.

Regards,

Iv.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Joe Peters May 16 at 03:23 PM
0

No, a calculated column is attached to a single table and therefore can only reference columns from that table. You can either create a derived table that combines both tables, or put the logic in the object's SELECT clause.

Share
10 |10000 characters needed characters left characters exceeded