Now, I want to use this table as a table_input in a Transformation. Whenever I add anything to Column Names I get the error "duplicate key activityid". There certainly are duplicate values in activityid. How do I get past this error? Why are duplicate value being checked for?
4 Community Answers
Kalyan Arangam —
I am unable to reproduce this issue. I created your table and inserted duplicate values and still works fine.
I would recommend we start by replicating this in a separate table.
Please make a copy of your table with some duplicate rows and see if you get the same issue on the new table.
If you do, please email us the DDL for the table and sample data. Its important we replicate this at our end. Also send us your log file from the Admin menu.
Note that you may not be able to attach items to this call. Please email the requested items with subject referencing ticket 15370.