Data integration - appending columns

Jonas Krarup Dam

Posted on 01/04/2025 15:17:59

Hey,

In the documentation, it says that I can combine columns by creating two mappings for the same destination column:
https://doc.dynamicweb.com/documentation-9/integration/integration-framework/data-integration-activities#sideNavTitle1-4-3

What version is required for this?
I'm trying to get it working on 9.17.3, but I get the error:
Error: Exception: Column names in each table must be unique. Column name 'PriceID' in table 'EcomPricesTempTableForBulkImport1' is specified more than once..
Do I need to upgrade, or is there something else I've missed?

Screenshot of my mappings is attached.

Thanks, Jonas.

Replies

Dmitriy Benyuk

Posted on 02/04/2025 11:05:59

This post has been marked as an answer

Hi Jonas,
there is a mistake in the documentation for DW9 as this feature was not implemented there. But it is already implemented in DW10:
Integration activities | Dynamicweb 10 Developer Documentation

So you can may consider the solution upgrade to DW10 instead.
BR, Dmitrij

Votes for this answer: 1

Jonas Krarup Dam

Posted on 02/04/2025 11:43:56

Hey Dmitriy,

Well, that's a shame - updating this solution is not an option right now :-)

I'll work around it, and look forward to using the functionality in a future DW10 project.

Thanks, Jonas

Dmitriy Benyuk

Posted on 02/04/2025 11:49:05

Ok, if interested you can find the changes for DW10 for this feature in this PR: Mss/13133 destination column concatenation by MatthiasSort · Pull Request #12 · dynamicweb/DataIntegration.SqlProvider
Or look in the destination writer source code for the latest version:
DataIntegration.SqlProvider/src/SQLDestinationWriter.cs at main · dynamicweb/DataIntegration.SqlProvider
BR, Dmitrij

You must be logged in to post in the forum

Developer forum

Data integration - appending columns

Replies