Forum Discussion

oscar_gutierrez's avatar
oscar_gutierrez
New Member
9 years ago
Solved

calculated columns: Data source name and tabla name

Hola Community,   i have created a new union table from several different tables and I need to know which records in my union atable come from each table.   I need to generate either: -calculate...
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi oscar_gutierrez,

    As dedelman_clng said, you create calculated columns in different tables. For example, you create it in source1 table and source2 table.

    Resource="resource1"
Resource="resource2"


    Then union the tables together including the "Resource" column.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi oscar_gutierrez,

As dedelman_clng said, you create calculated columns in different tables. For example, you create it in source1 table and source2 table.

Resource="resource1"
Resource="resource2"


Then union the tables together including the "Resource" column.

Best Regards,
Angelia