Magento 2 Custom Table Migration - Split data

Question

I try to migrate a custom table from Magento 1.9 to Magento 2.2. I managed this for some different tables with map.xml and "move". My problem with this table is, that the new version of the module split the data to different tables.

For example: Old Database:

Table 1: id, name, description

New Database:

Table 1: id, name

Table 2: name, description

How can I manage this with map.xml?

Thank you very much.

Answer 1

It cannot done via Data migration as per as my idea.

I suggest to you

create all 3column data on a another table from Magento.

After data-migration,copy data from that table to using MYSQL

Table 1: id, name

Table 2: name, description

It is best solution as per as my idea.

Answer 2

in map.xml

<source>
    ...
    <document_rules>
        <rename>
            <document>table_1</document>
            <to>table_2</to>
        </rename>
    </document_rules>
    ...
    <field_rules>
        ....
        <move>
            <field>table_1.id</field>
            <to>table_1.id</field>
        </move>
        <move>
            <field>table_1.name</field>
            <to>table_1.name</field>
        </move>
        <move>
            <field>table_1.name</field>
            <to>table_2.name</field>
        </move>
        <move>
            <field>table_1.description</field>
            <to>table_2.description</field>
        </move>

Of course, you need to be sure that the tables exist in the right (soruce/destination) databases.