求大神指教.非常感谢感谢感谢!!!!

问题: awk 做笛卡尔积运算

2个源文件如下:
#MXCpMd2ClstBO.csv
M09_2022,RBMIX_BH_FIRST_,RBS_IND_030_01N_S3BH17,true
M09_2022,RBMIX_BH_FIRST_,RBS_IND_040_02N_S3BH18,true
M09_2022,RBMIX_BH_FIRST_,RBS_IND_045_02N_S3BH19,true
M09_2022,RBMIX_BH_FIRST_,RBS_IND_060_04N_S3BH20,true
M09_2022,RBMIX_BH_FIRST_,RBS_IND_070_04N_S3BH21,true
M09_2022,RBMIX_BH_FIRST_,RBS_IND_080_04N_S3BH22,true
M09_2022,RBMIX_BH_FIRST_,RBS_IND_090_04N_S3BH23,true

#el_status.csv(MH EL)
M09_2022,RBMIX_BH_FIRST_,000008053672346299,true
M09_2022,RBMIX_BH_FIRST_,000008053672770957,true
M09_2022,RBMIX_BH_FIRST_,000008056597075077,true
M09_2022,RBMIX_BH_FIRST_,000008056597179607,true
M09_2022,RBMIX_BH_FIRST_,000008056597373593,false

实现效果: 前2列一样 交叉关联; el_status.csv 中第四列是 true 那么最后文件的最后列是3,否则最后列是1

类似:
M09_2022,RBMIX_BH_FIRST_,000008053672346299,RBS_IND_030_01N_S3BH17,3
M09_2022,RBMIX_BH_FIRST_,000008056597373593,RBS_IND_040_02N_S3BH18,1