发帖
雷达卡
| TABLEA： | ||||
| KEY | BIZ_RULE | Source | DIM | field_name |
| FAIL_R001 | AVD | table01 | A | name |
| FAIL_R002 | SWE | table02 | B | name |
| FAIL_R003 | DFSD | table03 | A | birth_date |
| FAIL_R004 | WE | table01 | B | tel_num |
| FAIL_R005 | SDF | table04 | A | mob_num |
| FAIL_R006 | SDF | table01 | B | age |
| FAIL_R007 | SDF | table02 | A | mob_num |
| FAIL_R008 | SDFy | table05 | B | sex |
| TABLE01: | ||||
| SOUECE | FAIL_R001 | FAIL_R004 | FAIL_R006 | customer_id |
| table01 | 0 | 1 | 0 | 1 |
| table01 | 0 | 0 | 0 | 2 |
| table01 | 0 | 0 | 0 | 3 |
| table01 | 1 | 1 | 0 | 4 |
| table01 | 1 | 0 | 0 | 5 |
| TABLE02: | |||
| SOUECE | FAIL_R002 | FAIL_R007 | customer_id |
| table02 | 0 | 1 | 1 |
| table02 | 0 | 0 | 2 |
| table02 | 0 | 0 | 3 |
| table02 | 1 | 1 | 4 |
| table02 | 1 | 0 | 5 |
| tableA是一个汇总信息表格，对应每个field_name和不同的DIM有一个KEY和一个biz_rule。然后有不同的source分别储存不容field_name的信息。0表示这个客户这个field_name里的信息没错，1就表示有错。其他的table03.04,05也是一样储存着表格A 中相应的信息。现在想要整理出一个总的表格，格式大概如下。里面A和B的意思是对应TableA里DIM=A或者DIM=B。XXX_BIZ_RULE也是取对应biz_rule. 之前是0的变为‘N’,1的变为“Y”。只要是Y的才写上biz_rule的具体内容。 |
| ustomer_id | name_A_fail | Name_A_biz_rule | name_B_fail | Name_B_biz_rule | mob_num_A_fail | mob_num_A_biz_rule | mob_num_B_fail | mob_num_B_biz_rule |
1 | N | N | Y | SDF | ||||
2 | N | N | N | |||||
3 | N | N | N | |||||
4 | Y | ADV | Y | SWE | Y | SDF | ||
5 | Y | ADV | Y | SWE | N |
求问该如何做比较好！！谢谢
京公网安备 11010802022788号
