Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Date relationship problem

hi all   I have 2 tables, both contain a day by dat date column in yyyy-mm-dd format.   There is a code asociated with each of the days. Code SP/B-0144.11 starts on 2/15/2019, while SP/B-0171.00 ...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Get rid of the many-to-many, they are evil, make things not work properly and are almost always avoidable. Implement a bridge table of unique key values.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Get rid of the many-to-many, they are evil, make things not work properly and are almost always avoidable. Implement a bridge table of unique key values.

  • o59393's avatar
    o59393
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    Hi Greg_Deckler 

     

    The problem is that products are added on a daily basis. Maintain a key of product+country will be kinda difficult.

     

    Any suggestion?

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Bridge Table = 

        DISTINCT(

          UNION(

            SELECTCOLUMNS('Query1',"Merged",[Merged]),

            SELECTCOLUMNS('Formulas',"Merged",[Merged])

          )

        )

       

      Zero maintenance required.

            

      • o59393's avatar
        o59393
        Icon for Post Prodigy rankPost Prodigy
        6 years ago

        hi Greg_Deckler 

         

        Here it is:

         

         

        But the values are still not filtering correctly:

         

         

        thanks!