Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
Try this one
Load * ,
longitude & "," & latitude as coordinates;
SQL SELECT unit,
longitude,
latitudeFROM medical.unit;
Try
SQL SELECT unit,
longitude,
latitude,
longitude || ',' || latitude as coordinates
FROM medical.unit;
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
try this one
SQL SELECT unit,
longitude,
latitude,
to_char(longitude) || ',' || to_char(latitude) as coordinates
FROM medical.unit;
Hi
Try this one
Load * ,
longitude & "," & latitude as coordinates;
SQL SELECT unit,
longitude,
latitudeFROM medical.unit;
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.
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...