源表和目标表结构不一致，源表列比目标表多。
1 需要配对的列名称：

LIST_ID

STATUS

REAL_NAME

REASON

PERSON_TYPE

AGENT_ID

CUSTOMER_ID

SOURCE_TYPE

DELETED

2 将列写入一个txt文件，比如a.txt：
LIST_ID
STATUS
REAL_NAME
REASON
PERSON_TYPE
AGENT_ID
CUSTOMER_ID
SOURCE_TYPE
DELETED

3 使用python读取该文件，生成配对参数：

 

	
	
		
		
			点击(此处)折叠或打开
		

	

	
		
		
			
			
				with open("a.txt","r") as f: 
			

			
				    a=f.readlines() 
			

			
				    b=[] 
			

			
				    for i in a: 
			

			
				        i=i.replace("\n","") 
			

			
				        print(i, "=", i, ",") 
			

			
				
			

			
				for i in b: 
			

			
				   print(i,"=",i,",")
			

		

	


4 输出结果：

LIST_ID = LIST_ID ,
STATUS = STATUS ,
REAL_NAME = REAL_NAME ,
REASON = REASON ,
PERSON_TYPE = PERSON_TYPE ,
AGENT_ID = AGENT_ID ,
CUSTOMER_ID = CUSTOMER_ID ,
SOURCE_TYPE = SOURCE_TYPE ,
DELETED = DELETED ,

5 写入参数文件。

ITPub博客

用python生成ogg的mapcol参数

最新文章