topic Re: Additional columns in external select in ArcGIS Survey123 Questions

Additional columns in external select

ZenMasterZeke — Wed, 09 Nov 2022 15:03:39 GMT

Howdy,

I have an external select with two csv files, sites and streets, in the media folder. The street field in my survey is correctly being filtered by a choice filter based on the selection in sites.

The streets.csv also has additional fields, such as city, state, zip, owner, phone, etc. However, I can't figure out how to extract that data from the csv. A regular pulldata function doesn't throw an error, but doesn't return anything either. I also don't see an itemsets.csv file in the media folder.

Any ideas on what the problem is and how to fix? Thanks.

Using Survey123 Connect version 3.15.165 with our ArcGIS Enterprise Portal.

Re: Additional columns in external select

DougBrowning — Wed, 09 Nov 2022 15:22:06 GMT

Can you post the pulldata call or the form. Not sure why you are talking about itemsets. You are using streets.csv.

should look like this

pulldata(name of csv without the .csv part, column name to return, lookup column name, lookup value)

I wish they wrote it like this in the help. The help for pulldata is pretty confusing.

hope that helps

Re: Additional columns in external select

ZenMasterZeke — Wed, 09 Nov 2022 16:15:23 GMT

Sure, thanks. Here are the three files. I was under the impression that S123 created an itemset.csv out of the two files in the media folder. No?

Re: Additional columns in external select

DougBrowning — Wed, 09 Nov 2022 16:48:03 GMT

That is only if you create and use a external choices tab. Otherwise you call the csv directly. Not sure why your form is a csv should be a xlxs.

Oh you have commas in there but it still actually works now so that is ok.

You have a choice filter in the pulldata line remove that. Also no need for a field that is just streets just put it right there like this

pulldata("streets", "sample_csz", "label",${street})

The issue you are having is that street field has a label of 123 main but the name is just 1. The name is what is stored. So when it does a lookup on 1 it finds nothing. You really do not want to store just a 1 in your data. I suggest change it to name and label the same

See attached. Hope that helps

Re: Additional columns in external select

ZenMasterZeke — Wed, 09 Nov 2022 20:42:08 GMT

Awesome, works great now. Thanks @DougBrowning