pulldata() missing some records

Question

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.

LeighErik · Answer

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>

JamesTedrick · Answer

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

LeighErik · Answer

LicenseNumberEstablishmentOwner NameOwner EmailLocation Addr Line 1Location CityLocation CountyF22AMERICAN LEGIONAMERICAN LEGION POST #19 110 E 3RD AVEBIG TIMBERSweet GrassF28EAGLES STOREEAGLE COMPANY INCEAGLES.MANAGER@WYELLOWSTONE.COM3 CANYON STWEST YELLOWSTONEGallatinF29STOCKMAN BAR & CASINOT J T105 MAINROUNDUPMusselshell CO/Central MT HlthF31VFW BARVFW POST 276 20 BAKERWHITEFISHFlatheadF35EAGLES CLUB FOE 689F O E # 689BOX 518CHINOOKBlaineF38VFW CLUBV F W 218 S MERRILLGLENDIVEDawsonF105CORNER BARPEGGY A ROST3212 EUCLIDHELENALewis and ClarkF119SWAN VALLEY CENTREAAA QUALITY SERVICES INC6799 HWY 83/MILE POST 42CONDONMissoula

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.