topic Re: "Duplicate Column Header" error when updating form in ArcGIS Survey123 Questions

"Duplicate Column Header" error when updating form

VickiG — Thu, 18 May 2023 19:55:36 GMT

Hi: I have been getting the error seen in the screenshot: "Duplicate Column Header: Unknown" and have searched the forum here and tried to backtrack to before the error and I am having no luck figuring out what happened.

I was changing a few fields to integer from select one lists and reordering some of the choice lists before this happened.

I have looked over the form many times and can't see an actual duplicate column header...does this error message cryptically refer to something else? 😉

I am using Survey123 Connect Version 3.17.55

I have attached the error message and a copy of the form.

Thanks for any ideas anyone may have!

Vicki

Re: "Duplicate Column Header" error when updating form

DougBrowning — Thu, 18 May 2023 20:24:26 GMT

It may be just getting tripped up since you have the repeat name and end repeat name the same. See the red here that is telling you its bad.

I ususally just call the end EndRepeatName to get around that. Try that.

Re: "Duplicate Column Header" error when updating form

VickiG — Thu, 18 May 2023 21:17:46 GMT

Hi Doug: I thought the red was just the app being helpful in keeping my place! 😉

But unfortunately changing those names to EndRepeat_tblName gave me the same error when I tried to update.

But now I have a "best practice" to use going forward.

I guess I will go back to a previous version of the survey that was working and update after every change so I can isolate the problem.

Thanks for your suggestion.

Vicki

Re: "Duplicate Column Header" error when updating form

DougBrowning — Thu, 18 May 2023 22:12:18 GMT

Oh I may have found it. I should have looked it was my other guess.

Re: "Duplicate Column Header" error when updating form

michaelclarks — Fri, 19 May 2023 13:15:49 GMT

he "Duplicate Column Header" error typically occurs when updating a form or spreadsheet where there are multiple columns with the same header name. This error message indicates that the column headers in the form or spreadsheet need to more be unique to avoid confusion and ensure accurate data organization.

To resolve this issue, you will need to make sure that each column header has a distinct name. You can do this by modifying the headers to include additional information or by renaming them entirely. For example, if you have two columns with the header name "Name," you can change one of them to "First Name" and the other to "Last Name.

Re: "Duplicate Column Header" error when updating form

VickiG — Mon, 22 May 2023 18:35:35 GMT

Hi again...sorry for the delayed reply, I was out of the office Friday. Wow, those are some eagle eyes! I would have never found those random inserts (how they got there??).

Unfortunately, I am still getting the error when I try to update the survey form.

I guess I will go back to last known working version and do iterative updates.

Thanks for the continued help!

Re: "Duplicate Column Header" error when updating form

VickiG — Mon, 22 May 2023 18:47:22 GMT

Hi Michael,

Thanks for the clear explanation. I thought I had figured it out, I had copied the original pages for survey, choices, etc. to another page within the workbook for reference, so I had duplicated headers within the workbook, but removing them didn't work.

So back to last know good configuration...at least I have one that is working.

Thanks again!

Re: "Duplicate Column Header" error when updating form

VerifyBtc — Sat, 17 Jun 2023 13:08:52 GMT

Here are a few steps you can follow:

Open your form editor: Access the form editor or builder tool that you are using to modify your form.
Review the column headers: Check all the column headers in your form. Look for any duplicates or columns with identical names.
Modify duplicate headers: If you find any duplicate column headers, rename them to make them unique. This could involve changing the text slightly of alicia devide or adding a number or identifier to differentiate them.
Update form settings: Once you have made the necessary changes to the column headers, save your modifications and update the form settings.
Test the form: After updating the form, test it to ensure that the "Duplicate Column Header" error no longer appears. Submit the form with sample data to verify that it functions as expected.

By ensuring that each column in your form has a unique header, you should be able to resolve the "Duplicate Column Header" error and proceed with updating your form successfully.

Re: "Duplicate Column Header" error when updating form

michaelmark865 — Wed, 27 Sep 2023 18:27:29 GMT

The "Duplicate Column Header" error typically occurs when you are working with a form or spreadsheet, and you are trying to update or modify the structure of the form or spreadsheet by adding a column with a header that matches the name of an existing column. This error is a protective measure to prevent data conflicts and maintain the integrity of the data.

Here are steps to resolve the "Duplicate Column Header" error:

Check for Duplicates: Review the headers of the columns in your form or spreadsheet. Ensure that there are no two columns with the exact same name. The headers must be unique to avoid conflicts.

Re: "Duplicate Column Header" error when updating form

michaelmark865 — Wed, 27 Sep 2023 18:30:15 GMT

thanks for information like outdoor furniture in UAE

Re: "Duplicate Column Header" error when updating form

jamesmichael7890 — Fri, 13 Oct 2023 17:30:22 GMT

The "Duplicate Column Header" error typically occurs when you are working with forms or spreadsheets, and it means that you have two or more columns with the same name or header. This can lead to confusion and issues when entering or analyzing data. Here's how to address and prevent this error

Re: "Duplicate Column Header" error when updating form

jamesmichael7890 — Fri, 13 Oct 2023 17:34:25 GMT

thanks to the Private Twitter Video Downloader

Re: "Duplicate Column Header" error when updating form

EricaNova — Mon, 26 Feb 2024 14:53:55 GMT

I had this issue as well. I found out that, interestingly, survey123 will check for column headers in different worksheets within your xlsx form. I had created a new worksheet, named "delete_later" and had pasted in some data there in case I needed to refer to it later. One of the column headers was labeled "hidden" and that's the column I got the warning about. So maybe don't create extra worksheet tabs for this purpose!!

Re: "Duplicate Column Header" error when updating form

DougBrowning — Mon, 04 Mar 2024 17:32:29 GMT

You could do this by using Right click Paste Values instead then it will not bring over the formulas.