Merge/Join Nodes - Annotate "R_" prefix to duplicate field names.
I'm currently using D360 to compare two datasets, all with exactly the same columns to verify whether the data is the same in both datasets.
I'm using the merge node - when doing so, I need to manually rename (or omit) each of the columns with matching column names.
Is there an easy way this can be achieved?
When performing this task with other tools/languages, often the prefix "R_" is annotated before the column with the same name - or other languages may gracefully use column_name_x and column_name_y, to prevent the user from receiving an error, and having to explicitly rename these columns.
Any tips appreciated - would love to know if this feature will be included by default in an upcoming release.
-
For those wondering the best way to tackle this situation, it would be to utilise the "rename by pattern" feature within the Merge node.
e.g. On the row where it states "Right fields" typing "R_*" will prefix all fields from the right side of the connection with "R_" and resolve any clashes caused by fields with the same name on either side of the merge relationship.
-
We're glad you found the solution and many thanks for posting it. Here is the corresponding Public docs link to the information you referenced
https://doc.infogixsaas.com/analyze/Default.htm#e-node-help/property-editors/field-list.htm
Please sign in to leave a comment.
Comments
2 comments