Help with Pull Data from .csv

[MichaelaOwens]

Hey everyone, I am a Survey123 novice and am using Survey123 Connect with an XLS Form to create my survey. I am trying to use the pull data calculation but I have been unable to get it to work. I have my .csv in the media folder and my pull data equation is as follows: pulldata('mcintosh','Totalalive','PlotID',${plot_id})

The PlotID field is being calculated based on the answer to three questions in the form, which creates the id of 3 numbers separated by two periods (ex: 0.3.2). I don't get any error messages when I save the XLS form but no data ever populates the field from my calculation. Attached are screenshots of my .csv, XLS form, and the form as seen in Survey123 Connect. Previous existing is the field where I am trying to get the pull data formula to return the value from the .csv. Any help is much appreciated. Thanks.

[BarbaraWebster1]

Hi @MichaelaOwens,

Is it possible to send the XLSForm and .csv file so we can take a closer look?

Thanks,
-Barbara

[MichaelaOwens]

Sure. The .csv only has the one entry that I am using to test the pull data function. Both the .csv and xls form are attached. Thanks.

[BarbaraWebster1 · Accepted solution]

Thanks for providing those. It looks like the issue is that there are duplicated column names in your .csv. If you delete two of the "Tech" columns, the pulldata expression will return the Totalalive value.

- Barbara

[MichaelaOwens]

Thank you so much!!