pulldata() missing some records

[ErikLeigh]

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. 

[ErikLeigh]

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. 

[JamesTedrick]

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).

[ErikLeigh]

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>