Forum Discussion

ABCD1234's avatar
ABCD1234
Regular Visitor
9 years ago
Solved

Slicer for multiple tables

Hi,   I have two tables. >Table1                                                     Product Value AB 123 12 AB 111 23 AC 199 34 AC 200 45 AD 999 56 > Table2 Prod ...
Need Help
  • DoubleJ's avatar
    DoubleJ
    9 years ago

    Then you can merge the tables and keep both columns. Following a way that might work in your case.

     

    1.  Let's say your 2 tables are as follows

      Table1Table2

    2.  In Query editor: Select "Merge Queries" - "Merge Queries as New"



    3. Select the Product Column in both tables and select "Full Outer" Join


    4. Click on the double headed arrow 

      This should lead to this table:




    5. Select "Add Column" - "Conditional Column" and set up a logic that combines the 2 product columns


      Result:



    6. Clean up your table by replacing null values, deleting superfluous columns etc.

     

     

    Hope this helps!
    JJ

DoubleJ's avatar
DoubleJ
Solution Supplier
9 years ago

Would it be an option to merge the tables?

ABCD1234's avatar
ABCD1234
Regular Visitor
9 years ago

The problem is that the values in both the tables are not related, for example the "Value" column in the first table could be Date and the "Some Value" in the second table could be a decimal. 

  • DoubleJ's avatar
    DoubleJ
    Solution Supplier
    9 years ago

    Then you can merge the tables and keep both columns. Following a way that might work in your case.

     

    1.  Let's say your 2 tables are as follows

      Table1Table2

    2.  In Query editor: Select "Merge Queries" - "Merge Queries as New"



    3. Select the Product Column in both tables and select "Full Outer" Join


    4. Click on the double headed arrow 

      This should lead to this table:




    5. Select "Add Column" - "Conditional Column" and set up a logic that combines the 2 product columns


      Result:



    6. Clean up your table by replacing null values, deleting superfluous columns etc.

     

     

    Hope this helps!
    JJ