Table not found for Store statement

[#1]

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

[giakoum · Accepted solution]

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

[rajat2392]

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

[rajat2392]

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

[Roop]

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.