SQL concant this should work

[#1]

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.

[#2]

Try

SQL SELECT unit,

     longitude,

     latitude,

     longitude || ',' || latitude as coordinates

FROM medical.unit;

[#3]

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

[#4]

try this one

SQL SELECT unit,

     longitude,

     latitude,

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

FROM medical.unit;

[perumal_41 · Accepted solution]

Hi

Try this one

Load * ,

   longitude & "," & latitude as coordinates;

SQL SELECT unit,

     longitude,

     latitudeFROM medical.unit;

[jagan]

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.

[#7]

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...