Select to view content in your preferred language

Publishing problems related to column names

585
1
Jump to solution
03-11-2024 05:45 AM
Victor_SebastianPerez_Castella
Emerging Contributor

Hi everyone. I´m having problems with the publish procedure. For each questión appear as a mistake this message 

  • Column names in each table must be unique. Column name 'adecuaci_other' in table 'db_20570.user_20570.survey123_f72754117880424bbf4ad7c03dab0235_SURVEY' is specified more than once.

So, i can´t publish any survey because of this.

@Ismael please

0 Kudos
1 Solution

Accepted Solutions
abureaux
MVP Frequent Contributor

Well, sounds like you have duplicate column names. Have you tried changing the columns name?

Also, keep in mind that if you are using select_one_or_other (or whatever that question looks like), it adds a column called "yourname_other" to your Feature Layer but NOT to Survey123. This can cause confusion and result in duplicate column names. Check for select_one_or_other. This may be what's going on here since your issue is specifically for "adecuaci_other"

Personally, I steer away from the select_one_or_other since it tends to cause more issues than it solves.

View solution in original post

1 Reply
abureaux
MVP Frequent Contributor

Well, sounds like you have duplicate column names. Have you tried changing the columns name?

Also, keep in mind that if you are using select_one_or_other (or whatever that question looks like), it adds a column called "yourname_other" to your Feature Layer but NOT to Survey123. This can cause confusion and result in duplicate column names. Check for select_one_or_other. This may be what's going on here since your issue is specifically for "adecuaci_other"

Personally, I steer away from the select_one_or_other since it tends to cause more issues than it solves.