Forum Discussion

sguenther's avatar
sguenther
Icon for Advocate II rankAdvocate II
9 years ago

Column contains blank values and this is not allowed

Hey,   I got a question regarding relationships. When updating my dataset in the service I often get the following error:   "Column 'Column1' in Table 'Table1' contains blank values and this is ...
Need Help
jasminwing's avatar
jasminwing
Icon for Advocate II rankAdvocate II
8 years ago

Hello

 

I am having the same issue. When building reports in the desktop version, I am unable to create a enw column as the error message is:

 

Column " in table" contains blank values and thsi is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

 

I am trying to use the following formula to calculate the number of days and weeks between two dates. I have used this basic formula on many other tables successfully.

 

REMEDIAL WEEKS = Completions[COMPLETED_DATE_WEEKNO] - Completions[CREATED_DATE_WEEKNO]

REMEDIAL DAYS = Completions[COMPLETED_DATE] - Completions[CREATED_DATE]

 

There is currently only one relationship involving the 'completions' table. It is linking a field called 'order number' to the 'order number' in another table. I can only set this as a 'many to one' relationship and it is the only field that is present in both tables in order for me to match them.

 

Any help would be greatly apprecaited.

 

Thanks