Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter table rows by Date Table , where Main Table contains dates in 5 columns and can be duplicate

Hi users,    I need to filter my table as per selected date or date range from Date table column (refer left side of the image) and I need to filter weather the range of those dates contains in my ...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous,

    I'd like to suggest you create a duplicate table and apply unpivot columns on the copied table, you can link this new table with raw tables and it does not affect the raw table relationships.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous , tried it and it throws an error to all the Table values. Also tried with changing the data type of these columns.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous,

I'd like to suggest you create a duplicate table and apply unpivot columns on the copied table, you can link this new table with raw tables and it does not affect the raw table relationships.

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous Seems, like it worked. Thanks , I didn't thaught of duplicating it , and not sure how its worked. 

     

    If you can explain on how its worked with duplicating table, and what will happen if I delete the previous table, which is not in use for any visuals ?

     

    Thanks again, marked that as a solution for this Issue.