Hi everyone
I’m trying to populate a column (3rd column in schema) using DataSetColumn from a lookup DataSet and using dynamic filling. Only 1000 rows.
Unfortunately it is raising the error shown below at times when generating the Preview; however seems unpredictable/random when the error will pop and I cannot identify the root cause.
Update Dataset and Generate Data both result in the error present in the results. Again, some time works but sometimes fails when generating Preview.
There are prior columns in the schema (2nd column) that is filled with the same method but from a different DataSet.
The lookup DataSet is small, two columns and not missing any values (proven because sometimes the Preview works).
Not sure if related, but in the same schema, for another field (6th column) I’m populating the values using a scenario and a formula. I have the impression that the error started to bug me once I added that field.
I’ve cleared cache browser, redefined the schema from scratch multiple times (not deleting the schema, just deleting the fields), reduced the number of fields in the schema but at the end I get blocked at some point by the same error.
Could anyone kindly advice?
Thanks in advance,
Manuel
error: organ_toxicity: error: Could not access blank value: Use || to provide a default value for blank fields. Example: (my_field || 0) + 1
schema: /schemas/692053
lookup:/datasets/354901
scenario: /scenarios/9365
Edit:
I’m now suspecting that when trying to use dynamic assignments using zeros is the root cause of the random error.
See below. I’m trying to model that for certain chemicals there are no outcomes of specific types (e.g Saccharin does not produce effects B or C)
When using just random dynamic assignment there are no errors
schema: toxicology_adverse_effects (schemas/692234)
column: organ_toxicity
source: datasetcolumn
lookup: toxicity_lookup_adverse_effect
dynamic assignment table:
A B C D
chemical == 'Saccharin' 6 0 0 1
chemical == 'Na-Saccharin' 0 0 1 2
chemical == 'K-Saccharin' 0 4 1 0
chemical == 'Ca-Saccharin' 1 0 3 0
