Peek returns empty value - get error

mferrarini88 — Tue, 08 Oct 2019 15:53:30 GMT

I have a table called INIZIATI wich contains a field called IndirizzoCliente.

After that I have this code

DataGM: LOAD * INLINE [Address, latitude, longitude '', 0,0 ]; let noRows = NoOfRows('INIZIATI')-1; for i=0 to $(noRows) LET ind = peek('IndirizzoCliente', '$(i)', 'INIZIATI'); if not isnull($(ind)) AND len($(ind)>0) then CONCATENATE DataGM: LOAD '$(ind)' as Address1, [result/geometry/location/lat] as latitude, [result/geometry/location/lng] as longitude FROM [<a href="https://maps.googleapis.com/maps/api/geocode/xml?address=$(C)&key=$(vKey)&sensor=false" target="_blank">https://maps.googleapis.com/maps/api/geocode/xml?address=$(C)&key=$(vKey)&sensor=false</a>] (XmlSimple, Table is [GeocodeResponse]); end if NEXT i;

(The a href s not in my code, is displayed when I pasted my code in this website and I can't remove it.)

It seems that $c is completely empty because I'm getting this error:

Re: Peek returns empty value - get error

Vegar — Wed, 09 Oct 2019 04:40:54 GMT

Try this:

isnull('$(ind)') AND len('$(ind)'>0)

topic Re: Peek returns empty value - get error in QlikView

Peek returns empty value - get error

Re: Peek returns empty value - get error