metacore fails if the value level is blank

[statasaurus]

(Can use the r/pharma workshop excel to test this)

[kaz462]

Thanks, @statasaurus
This issue is from spec_type_to_derivations:
ls_derivations %>% reduce(bind_rows) - cannot combine Variables$dataset <character> and ValueLevel$dataset <logical> due to different column types, because current blank columns are read as "logical" by default.

Potential resolution:
update read_all_sheets by adding col_types in read_excel(..., col_types = "text")