topic Re: Table not found for Store statement in QlikView

Table not found for Store statement

Wed, 16 Apr 2014 05:05:46 GMT

Hi Experts,

For the Below Code I am getting table not found Coordinates.csv while using Store command.

Please help out.

------------------------------------Code-----------------------------------------------------------------------

if (IsPartialReload()=-1) then

Coordinates:

LOAD PostalCode,

Latitude,

Longitude,

Coordinates

FROM

(txt, utf8, embedded labels, delimiter is ',', msq);

temp:

LOAD

'$(newPinCode)' as PostalCode,

[place/lat] as Latitude,

[place/lon] as Longitude,

TEXT([place/lon]) & ',' & TEXT([place/lat]) as Coordinates

//[place/display_name] as Address

FROM [http://nominatim.openstreetmap.org/search?q=$(newPinCode)&format=xml&addressdetails=0&countrycodes=in&accept-language=en&limit=1] (XmlSimple, Table is [searchresults]);

Sleep 1000;

Coordinates:

Concatenate

load PostalCode,

Latitude,

Longitude,

Coordinates

Resident temp;

store Coordinates into Coordinates.csv(txt, delimiter is ',');

ENDIF

Re: Table not found for Store statement

giakoum — Wed, 16 Apr 2014 08:32:13 GMT

Coordinates and temp have the same fields so they are auto concatenated by QlikView.

Check the name of that table (likely it will be temp) and store that one. You do not need to concatenate them manually

Re: Table not found for Store statement

rajat2392 — Wed, 16 Apr 2014 10:12:38 GMT

try the below code

----------------------------------------------------------------------code--------------------------------------------------------------------

if (IsPartialReload()=-1) then

Coordinates:

LOAD

PostalCode,

Latitude,

Longitude,

Coordinates

FROM

(txt, utf8, embedded labels, delimiter is ',', msq);

NoConcatenate

temp:

LOAD

'$(newPinCode)' as PostalCode,

[place/lat] as Latitude,

[place/lon] as Longitude,

TEXT([place/lon]) & ',' & TEXT([place/lat]) as Coordinates

//[place/display_name] as Address

FROM [http://nominatim.openstreetmap.org/search?q=$(newPinCode)&format=xml&addressdetails=0&countrycodes=in&accept-language=en&limit=1] (XmlSimple, Table is [searchresults]);

Sleep 1000;

Concatenate(Coordinates)

load

PostalCode,

Latitude,

Longitude,

Coordinates

Resident temp;

store Coordinates into Coordinates.csv(txt, delimiter is ',');

ENDIF

Re: Table not found for Store statement

rajat2392 — Wed, 16 Apr 2014 10:20:11 GMT

try the below code..and please place the link instead "YOUR URL LINK" while loading temp table in below script...

----------------------------------------------------------------------code--------------------------------------------------------------------

if (IsPartialReload()=-1) then

Coordinates:

LOAD

PostalCode,

Latitude,

Longitude,

Coordinates

FROM

(txt, utf8, embedded labels, delimiter is ',', msq);

NoConcatenate

temp:

LOAD

'$(newPinCode)' as PostalCode,

[place/lat] as Latitude,

[place/lon] as Longitude,

TEXT([place/lon]) & ',' & TEXT([place/lat]) as Coordinates

//[place/display_name] as Address

FROM [YOUR URL LINK] (XmlSimple, Table is [searchresults]);

Sleep 1000;

Concatenate(Coordinates)

load

PostalCode,

Latitude,

Longitude,

Coordinates

Resident temp;

store Coordinates into Coordinates.csv(txt, delimiter is ',');

ENDIF

Re: Table not found for Store statement

Roop — Wed, 16 Apr 2014 10:21:09 GMT

Yes, quite often QlikView will not create a new table with identical fields to the one just read.

So you do not require any of the Coordinates section and I would delete it, and rename temp to Coordinates - That should then give you what you want.