Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Table not found for Store statement

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=i...] (XmlSimple, Table is [searchresults]);

  Sleep 1000;

Coordinates:

Concatenate

load PostalCode,

     Latitude,

     Longitude,

     Coordinates

Resident temp;

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

ENDIF

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Table not found for Store statement

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

View solution in original post

4 Replies
Partner
Partner

Re: Table not found for Store statement

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

View solution in original post

Highlighted
Partner
Partner

Re: Table not found for Store statement

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=i...] (XmlSimple, Table is [searchresults]);

  Sleep 1000;

Concatenate(Coordinates)

load

     PostalCode,

     Latitude,

     Longitude,

     Coordinates

Resident temp;

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

ENDIF

Partner
Partner

Re: Table not found for Store statement

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

rupe
Valued Contributor

Re: Table not found for Store statement

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.