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.
Please sign in to leave a comment.