Shulou(Shulou.com)06/02 Report--

Today, I will talk to you about how to use python to generate the mapcol parameters of ogg. Many people may not know much about it. In order to make you understand better, the editor has summarized the following for you. I hope you can get something according to this article.

The structure of the source table and the target table is inconsistent, and the source table has more columns than the target table.

1 column names that need to be matched:

LIST_IDSTATUSREAL_NAMEREASONPERSON_TYPEAGENT_IDCUSTOMER_IDSOURCE_TYPEDELETED

2 write the column to a txt file, such as a.txt:

LIST_ID

STATUS

REAL_NAME

REASON

PERSON_TYPE

AGENT_ID

CUSTOMER_ID

SOURCE_TYPE

DELETED

3 use python to read the file and generate pairing parameters:

Click (here) to collapse or open 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 output result:

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 write the parameter file.

After reading the above, do you have any further understanding of how to use python to generate the mapcol parameters of ogg? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.