Rule blocked: SEND-359

[JozefAerts]

SEND359 does regular expression testing whether a value is a number, and this on 6 variables, of which 3 are "explicit" (RPPLDY, RPPLSTDY and RPPLENDY), and 3 are "generic" (--RPDY, --RPSTDY, --RPENDY).
As soon as one of the latter (one of the "generic" ones) is added, the execution in the rule editor fails with the error:
"error":"An unknown exception has occurred"
"message":"Cannot perform 'ror_' with a dtyped [bool] array and scalar of type [NoneType]"

When I comment out the parts for the "generic" ones (--RPDY, --RPSTDY, --RPENDY), so only keep RPPLDY, RPPLSTDY and RPPLENDY, the rule execution runs just fine.

[gerrycampion]

Even though this is SEND, it appears to be a general issue, so it should still be resolved in 1.0. Note that there is an issue with the check and with the output variable reporting.

[SFJohnson24]

the wildcard does not appear to be replaced in issues that are reported, it is however reported correctly in scope skips.
the wildcard should be replaced for all checks from #1590 -- this may be isolated to only generate_errors_by_target_presence() but I would check that the wildcard is functioning as expected in the check operators then check the error logic

[SFJohnson24]

@JozefAerts your data has whitespace around several of the columns--the key one being domain. This causes engine to have issues with replacing the prefix. CORE-Report-2026-03-11T14-54-58.xlsx

[JozefAerts]

@SFJohnson24 Could you make the corrected test file that generated the above CORE report available to me?
Even when removing the whitespace in mine, I keep getting propblems, which may be due that we don't use Excel, but an alternative named "Planmaker". I keep trying though.

[SFJohnson24]

@JozefAerts
Datasets.json
Datasets.xlsx

there was whitespace around DOMAIN, --SEQ, as well as STUDYID. I added a PR to scrubheaders from json and excel datasets to avoid this in the future

[JozefAerts]

@SFJohnson24 Great! Works as expected now.
Still puzzled why my Excel didn't work ...