datav关联关系展示

1.数据中显示担保方与被担保方之间的关系

表数据抽取

insert into t_correlation_item (Name)  
(select distinct(a.Name)  
from
 (select * from (select distinct(FULL_NAME_SECURED_PARTY) as Name 
from  major_event_external_guarantees_detail_simple) b where b.Name not in ( select Name from t_correlation_item) ) a);

delete from t_correlation_item where Name not like '%公司%' 
and  Name not like '%医院%' 
and Name not like '%厂%'
and Name not like '%集团%'
and Name not like '%银行%'
and Name not like '%局%'
and Name not like '%所%'
and Name not like '%土地%'
and Name not like '%电%'
and Name not like '%营体%'
and Name not like '%中铁%'
and Name not like '%地产%'
and Name not like '%中心%'
and Name not like '%学校%'
and Name not like '%研究%'
and Name not like '%社%'
and Name not like '%