示例: id Disease1 Disease2 Disease302 NA disease2 NA
03 disease1disease2 NA 如何将多个列中的不同值转换为1,然后改变一个新列,计算特定列(可能在第22:65列)中的总数为1,或者更好的starts_with()。期望输出 id Disease1 Disease2
| Additional_Disease1 | Additional_Disease2 | Additional_Disease3 | Additional_Disease4 | Room | from ( union all select Additional_Disease1from tb_data
union all select Additional_<