Method for solving data automatic mapping

The invention particularly relates to a method for solving automatic data mapping. The method solves the problem of automatic data mapping by defining a data association table and a mapping rule tablein a database; each target data corresponds to a mapping rule. If the source data can match the mapping rule, the association relationship can be established with the target data to realize one-to-one, one-to-many and many-to-many mapping scenarios between the target data and the source data. Foreground functions are defined to enable users to maintain mapping rules themselves; a view that converts mapping rules to regular expressions is converted. In the method for solving the automatic data mapping, the user only needs to sort out and maintain the mapping rules by himself, and when the newmaterial is added, the system will automatically find the matching cost object and automatically establish the association relationship, which not only reduces the pressure of the business personnel,but also has high flexibili