Forum Discussion

janwillem's avatar
janwillem
Frequent Visitor
9 years ago

Combining Tables with identical fields

I have 2 companies with the same table-columns.

Company A - Table "Company A - Purchase Line "

| Columns "Qty Purchase Line" - "Qty Received" - "Qty to Receive"  ->           No Company name in it.

Company B - Table "Company B - Purchase Line" | Columns "Qty Purchase Line" - "Qty Received" - "Qty to Receive"  ->             No Company name in it.

 

I will combine these 2 tables and filtering on Company:

Qty Purchase Line A+B;

Qty Received A+B;

Qty to Receive A+B.

            +

Slicer on Company

 

How can I do this?

 

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    Hi janwillem

     

    You can create a new Calculated Table that combines these 2 tables and adds a column for Company Name

     

    Go to Modelling Tab>>>NEW TABLE

     

    New Table =
UNION (
    ADDCOLUMNS ( TableCompanyA, "Company Name", "Company A" ),
    ADDCOLUMNS ( TableCompanyB, "Company Name", "Company B" )
)