Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

slice tow tables

Hi,

 

There are two tables Pairil and sov in those no common column is there want to slice the data using the peril type. But by using those both the data shall be get sliced . I have tried joint, append but those are not working can anyone give any idea how can I combine both the tables or relate them so as slicer can be applied on both the tables.

 

 

 

 

 

 

 

 

 

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    4 years ago

    Hi Anonymous ,

     

    Add both tables to your data model.

    Relate perilTypeSlicer[PerilType] to sov[PerilType].

    Use perilTypeSlicer[PerilType] in your slicer visual.

     

    Pete

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    May you should still try the append operation.

    Then keep A through the filter.

     

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.