Skip to Content
avatar image
Former Member

Calculated Column Data Foundation (Using SQL)

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 16 at 03:23 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded