topic Re: Can you use pulldata() to grab data from multiple rows from CSV? in ArcGIS Survey123 Questions

Can you use pulldata() to grab data from multiple rows from CSV?

Anonymous User — Wed, 02 Oct 2019 19:53:08 GMT

I am creating a survey to assess park's operations. Within each park there are multiple operation id's for assessment.

I want to use pulldata() to list out the id's in the park, not just one. I need to do this for other features in the parks, like there may be multiple playground units in one park and I want to display all of their id's/info as well.

Here is an example of my csv looks like:

ParkID	OperationID	ParkName
1000	00025	Julia's Walk Park
1000	00035	Julia's Walk Park
1002	0009	Main Street Promenade

I don't have to have to concat several opid's within the pulldata() formula because not all of the parks contain multiple id's, and there isn't a set number of ops or features per park.

Thanks!

Re: Can you use pulldata() to grab data from multiple rows from CSV?

Anonymous User — Thu, 03 Oct 2019 06:20:01 GMT

Hi Caryn,

Unfortunately not, due the nature of how pulldata() works, it will return only one single value for the first value it finds in the list that matches the search criteria.

Phil.

Re: Can you use pulldata() to grab data from multiple rows from CSV?

AndrewE — Thu, 03 Oct 2019 12:44:05 GMT

Is this something that custom pulldata java script functions might be able to do once they are enabled?

Re: Can you use pulldata() to grab data from multiple rows from CSV?

Anonymous User — Thu, 03 Oct 2019 12:47:32 GMT

Hi Andrew,

Yes, you could use a javascript function to return multiple values as an array or list from a csv file by searching and returning all the values that match the input value.

Phil.

Re: Can you use pulldata() to grab data from multiple rows from CSV?

ChrisRoberts2 — Fri, 29 Oct 2021 02:36:08 GMT

Hi Phil

Do you have an exmaple on how you would achieve this? For example the extract of a table used in a pulldata function has multiple common names. If a user picks a common name that is not unique I would like to show a warning in a Note or something to show them the unique sub species or scientifc name to ensure they pick the right species.

Cheers

Chris

Re: Can you use pulldata() to grab data from multiple rows from CSV?

PavlovaVitale — Thu, 22 Feb 2024 22:09:31 GMT

how would you do that?