Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

concatenating two tables

Dear all,     I have two tables Overdue,Bounce.   Overdue: Customer name, Customer no, DOB, Accountno, Monthyr, Key   Bounce: Accountno, Monthyr, Key, EMI amount, Par     Now i w...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    You can new a calculated table with below formula:

    NewTable =
UNION (
    SELECTCOLUMNS (
        Overdue,
        "Accountno", Overdue[Accountno],
        "Monthyr", Overdue[Monthyr],
        "Key", Overdue[Key]
    ),
    SELECTCOLUMNS (
        Bounce,
        "Accountno", Bounce[Accountno],
        "Monthyr", Bounce[Monthyr],
        "Key", Bounce[Key]
    )
)



    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

You can new a calculated table with below formula:

NewTable =
UNION (
    SELECTCOLUMNS (
        Overdue,
        "Accountno", Overdue[Accountno],
        "Monthyr", Overdue[Monthyr],
        "Key", Overdue[Key]
    ),
    SELECTCOLUMNS (
        Bounce,
        "Accountno", Bounce[Accountno],
        "Monthyr", Bounce[Monthyr],
        "Key", Bounce[Key]
    )
)



Best regards,

Yuliana Gu