Forum Discussion

dev3102's avatar
dev3102
New Member
2 years ago

Relationship between tables not complete

I have a .xls file with a time stamp column, that has a few missing dates between 01/11/2021 to today. To check what these dates are I created a reference date table as below:

 

 

I have established a 1:1 relationship between  Reference Table [Ref Date] and Timestamp, but for some reason the dates don't seem to flow all the way through and stop at a random date on 15/04/22.

 

I checked the timestamp column and it does seem to have dates beyond 15/04/2022. Not sure what's causing the problem. Any help would be appreciated!! Thanks in advance!

 

 

Need Help

2 Replies

  • audreygerred's avatar
    audreygerred
    Super User
    2 years ago

    Hi! For the data you have that is after 15/04/2022 can you check to make sure the portion remained at 30 minute intervals? Are these fields formatted as text or as date/time?

  • dev3102's avatar
    dev3102
    New Member
    2 years ago

    Hi,

     

    Thanks for your reply! 🙂

     

    On the timestamp column, the intervals seem to remain at the 30 min interval. In fact removing the RefDate column from the visual, I can see the values in the timestamp column

     

    Same for the refDate column

     

     

    But when I add both colums to the visual one of them always throws blanks.