Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Return (Blank) after replacing data table

Hello,   I replaced a Sales data table. After replacing (loading, transforming, cleaning, formatting etc.) the Sales table seemed to work as well as the old Sales table. However when I managed the...
Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Anonymous ,

 

The relationship between 2 tables is single directional. From which table are you using your DATE filter?

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Pragati11 

 

The all-pages filter is from my calendar table.

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Anonymous ,

     

    On what column have you created the relationship? DATE column in both the tables?

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Pragati11 

       

      The relationship is 1-to-many from Calendar/Date to sale_order/date_order

      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        Hi Anonymous ,

         

        The format of Calendar-->Date and sale_order-->date_order columns is same right? 

        Share some screenshot on data format for these 2 columns.

         

        Thanks,

        Pragati