Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Relationship with Dates

In order to have "Age group" for my data set, i've created a help table with "birthday" as unique dates.  But when i try to link it to birthday, i keep telling me it's not unique.  Any1 knows why...
Need Help
GilesWalker's avatar
GilesWalker
Skilled Sharer
10 years ago

Anonymous - I have had something like this happen before with Excel documents. Go into the query editor and in the Birthdays file have a look at the bottom of the table and see if there are any values there. I have foud sometimes there are a couple random rows at the bottom and these cause the issue.

 

Giles

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    any easy way to go to the bottom of the page? as the birthday are covers from 1900 to today. very long list.  thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    GilesWalker

    any easy way to go to the bottom of the page? as the birthday are covers from 1900 to today. very long list.  thanks.

     
    • GilesWalker's avatar
      GilesWalker
      Skilled Sharer
      10 years ago

      Anonymous - you can click on the filter button and see if any thing other than numbers shows up. otherwise just scroll all the way.

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        GilesWalkeri'm unable to see all the values from filters, as it's "limit of 1000 values reached. but looks like it's all dates.