topic SQL concant this should work in QlikView

SQL concant this should work

Tue, 18 Nov 2014 01:31:27 GMT

I have had a problem with this. It should work but I don't have any idea why it doesn't.

SQL SELECT unit,

longitude,

latitude,

longitude & "," & latitude as coordinates

FROM medical.unit;

the longitude and latitude comes up but coordinates shows 0

pre thanks for help.

Re: SQL concant this should work

Tue, 18 Nov 2014 01:46:51 GMT

Try

SQL SELECT unit,

longitude,

latitude,

longitude || ',' || latitude as coordinates

FROM medical.unit;

Re: SQL concant this should work

Tue, 18 Nov 2014 01:55:00 GMT

thank you It did get me something other than 0.... it was 1

but not quite what I expect

what I have is longitude 98.1234 and latitude 23.8569

what value I want is

98.1234,23.8569

using it for a map plotting

Re: SQL concant this should work

Tue, 18 Nov 2014 03:06:16 GMT

try this one

SQL SELECT unit,

longitude,

latitude,

to_char(longitude) || ',' || to_char(latitude) as coordinates

FROM medical.unit;

Re: SQL concant this should work

perumal_41 — Tue, 18 Nov 2014 03:16:51 GMT

Try this one

Load * ,

longitude & "," & latitude as coordinates;

SQL SELECT unit,

longitude,

latitudeFROM medical.unit;

Re: SQL concant this should work

jagan — Tue, 18 Nov 2014 03:35:30 GMT

Hi,

Try like this in Qlikview using Preceding load

TableName:

LOAD

Text(longitude) & ',' & Text(latitude) as coordinates;

SQL SELECT unit,

longitude,

latitude

FROM medical.unit;

Hope this helps you.

Regards,

jagan.

Re: SQL concant this should work

Tue, 18 Nov 2014 03:45:18 GMT

Thank you both Perumal and Jagan both worked flawlessly and I hope this helps others also since I could not find any answers, which is why I posted the question.... you guys are awesome...