check if a column name is on another file to duplicate

hilsiahr

hi everyone!

im working with a dynamic rename for a mapping but as i know, i cannot have duplicate names on the tool, for example id, id so i want to rename left part of the dynamic rename tool , what i want is this

depending on how many times a field is on the file 2, that would be the name of _values i will have as columns

thanks for the help

RaphaelSilva

How are you planning the File 2 to add the id_1 information on the first file? I don't understand how the dynamic rename would work here, can you clarify better the situation so we can support you better?