topic pulldata() missing some records in ArcGIS Survey123 Questions

pulldata() missing some records

ErikLeigh — Fri, 17 Mar 2017 14:57:38 GMT

I'm trying to use the pulldata() function as a license record lookup to populate data in a form header. It seems to work almost all the time, but for some reason it will not return specific records when chosen and I can't figure out why. It doesn't seem to be a coding issue because it works just fine on other records using the exact same parameters in pulldata(). I thought maybe there were some sort of text character issues, but again, I can't figure out what. Any suggestions would be appreciated.

Re: pulldata() missing some records

ErikLeigh — Fri, 17 Mar 2017 16:59:59 GMT

LicenseNumber	Establishment	Owner Name	Owner Email	Location Addr Line 1	Location City	Location County
F22	AMERICAN LEGION	AMERICAN LEGION POST #19		110 E 3RD AVE	BIG TIMBER	Sweet Grass
F28	EAGLES STORE	EAGLE COMPANY INC	EAGLES.MANAGER@WYELLOWSTONE.COM	3 CANYON ST	WEST YELLOWSTONE	Gallatin
F29	STOCKMAN BAR & CASINO	T J T		105 MAIN	ROUNDUP	Musselshell CO/Central MT Hlth
F31	VFW BAR	VFW POST 276		20 BAKER	WHITEFISH	Flathead
F35	EAGLES CLUB FOE 689	F O E # 689		BOX 518	CHINOOK	Blaine
F38	VFW CLUB	V F W		218 S MERRILL	GLENDIVE	Dawson
F105	CORNER BAR	PEGGY A ROST		3212 EUCLID	HELENA	Lewis and Clark
F119	SWAN VALLEY CENTRE	AAA QUALITY SERVICES INC		6799 HWY 83/MILE POST 42	CONDON	Missoula

Just an example of my data and code I've tried using. The yellow highlighted rows fail to return anything. The other records work just fine.

Re: pulldata() missing some records

JamesTedrick — Fri, 17 Mar 2017 21:46:38 GMT

Hi Erik,

Is it possible to create a select_one from your LicenseNumber column and test that? I'm not seeing anything obvious (unless there's extra white space in some values- you might want to open the CSV in a text editor and check).

Re: pulldata() missing some records

ErikLeigh — Fri, 17 Mar 2017 22:40:59 GMT

Hi James,

Thanks for the follow-up. I would rather not do a select_one as a permanent fix. There are over 11 thousand records in my full data set. I could erase the majority and test it however.

Sincerely,

Erik Leigh, RS

Montana DPHHS

Food and Consumer Safety Section

1400 Broadway, Room C-214

Helena, MT 59620

406-444-5306

eleigh@mt.gov<mailto:eleigh@mt.gov>