cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ajsjoshua Regular Visitor
Regular Visitor

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 want to create a new table which should only has Accountno,Monthyr,Key from both these table

 

Newtable:

Accountno,

Monthyr,

Key

 

 

Regards,

Joshua.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: concatenating two tables

Hi @ajsjoshua,

 

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: concatenating two tables

Hi @ajsjoshua,

 

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.