Add Source to Column Names

Mike Pearson
Mike Pearson Member
in General

Is there a way to bulk update/set an option to add the Source name to all columns, rather than just the _1 on the second source?

For example, if Source1 and Source2 both have an ID column, then columns would be named Source1.ID and Source2.ID, rather than ID and ID_1 which is ambiguous outside of the workflow.

Best Answer

  • Fatme Kungyova
    Fatme Kungyova Experian Employee
    Answer ✓

    Hi Mike,

    One option is when you press on 'Show step results' then go to 'Transform' and select all the columns you want to rename. Then at the top menu look for 'Rename', which will give you few different options for renaming all selected columns at ones.

    From your description, I believe that the 'Search and replace' option inside the 'Rename' would work well.

    I hope this helps! 🙂

Answers

  • Mike Pearson
    Mike Pearson Member

    Thanks Fatme, that's that helps a lot.

    Suffix option to add the source to all column name, then followed with search and replace for _1 in my example will do the trick perfectly (or suffix rename step to each source prior to joining).

Categories