Issue with Transform Map Creating Duplicate Columns

[monica190]

Hi Team,

I am facing an issue with a transform map. There is an OOB transform map for one of the HAM tables. The user has the option to download a template and execute the job.

For one of our requirements, we were asked to enable this functionality from the front end. To achieve this, I created a catalog form and set up a flow.

In the flow, I am creating a data source and reusing the same transform map, triggering a custom action to run it.

However, during this process, I noticed that new columns are being created, even when columns with the same display name already exist. The newly created columns have a backend name prefixed with "u_", despite having identical display names.

I want to prevent these duplicate columns from being created. Could someone advise on how to achieve this?

From the SS you can see 2 columns with Display name as Asset tag 

[ersureshbe]

Hi,

To troubleshoot the issue, I suggest employing a step-by-step approach. Begin by testing with only two fields in your load. This will help determine whether a new column has been created. Additionally, in your import set table, please verify if any code has been written and confirm whether that code exists to facilitate the creation of a new column.