Column name or path duplicated in 'source' under 'mappings

Question

Hi,

I am getting following error during pipeline run.

Operation on target ac_ApplyMapping failed: Column name or path 'StudentId' 
duplicated in 'source' under 'mappings'. Please check it in 'mappings'. 

In the Copy Activity we are applying following mappings.

{
    "type": "TabularTranslator",
    "mappings": [{
            "source": {
                "name": "StudentId",
                "type": "string"
            },
            "sink": {
                "name": "StudentId_Primary",
                "type": "string"
            }
        }, {
            "source": {
                "name": "StudentId",
                "type": "string"
            },
            "sink": {
                "name": "StudentId_Secondary",
                "type": "string"
            }
        }
    ]
}

Is there any way to handle this scenario?

Answer 1

Hello @Abhishek Vyas ,

Thanks for the question and using MS Q&A platform.

Duplicating mappings in copy activity is not allowed.

Workaround:

Step1: Copy activity => Source Tab contains a feature to add "additional columns". Using this, add a new column on top of your source columns to duplicate StudentID.

Copy Activity Source tab configurations :

Step 2: In Copy activity => Mappings use above added new column for Secondary Student ID mapping.

Hope this helps. Do let us know if you any further queries.

---------------------------------------------------------------------------

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.