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?
6 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.
The fact that there is a table with an understore (_) in the name and one with a dash (-) seems to be the problem. Also, the identity field in mt-documents is required. No data is required in either table.
I have run the above DDL in an orchestration using the SQL component and then used that table in a table input (with no data). So i have both a mt-documents table and a mt_documents table. The table input component does not return any errors for me. Are these the steps you are following to reproduce the issue?
Can you confirm the version of Matillion you are running please.