Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I use the following query to load data from database to Qlik sense, Qlik Sense would complain 'no myDate field found'. Could you please give any suggestion? Thanks!
I have connected to the database, and the connection is correct. I can not just use 'Load *, because I would like to some Qlik Sense function during loading data, such as 'GeoMakePoint ', 'Date()'.
Load
myDate ,
date_String ,
myVlaue ,
latitude ,
longititude ,
GeoMakePoint ( latitude , longititude ) as myLocation
Select
TO_DATE(from_unixtime(UNIX_TIMESTAMP(date_String , 'M/dd/yyyy'))) as myDate ,
date_String ,
myVlaue ,
latitude ,
longititude
From myTable
Depending on the database, the myDate in the SQL may be returned upper case. What database is it?
Try a couple things.
1) Refer to it as MYDATE (upper case) in the LOAD statement.
2) Quote in the SQL:
Select
TO_DATE(from_unixtime(UNIX_TIMESTAMP(date_String , 'M/dd/yyyy'))) as "myDate"
-Rob
hey...
Missing ';' after myLocation.
Hi Marco, thanks for your help!
Missing ' ; ' between Load part and Select part is a type error when I copy script from Qlik sense to Qlik community.
When I run the query with ' ; ' in the above query, Qlik sense would complain: Field not found - <myDate>
Any suggestion is appreciated!
Depending on the database, the myDate in the SQL may be returned upper case. What database is it?
Try a couple things.
1) Refer to it as MYDATE (upper case) in the LOAD statement.
2) Quote in the SQL:
Select
TO_DATE(from_unixtime(UNIX_TIMESTAMP(date_String , 'M/dd/yyyy'))) as "myDate"
-Rob
Is true. In Oracle DB exists only upper fields x.x
Rob , thanks so much for your help!
I use Oracle.
1) Refer to it as MYDATE in the LOAD part, works.
2):Add " " to myDate at Selection part, also works.
when I load data from Apache Hive table, all the field name is lower case. Be careful about the upper/lower case.