Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I just put all my test material into a mysql server and trying to fetch the data from there...
But Im trying to use the scripting from the original qlikview file, but I have some problems
When I use "Dual(Month(created) & ' ' & Year(created),year(created) & num(month(created), '00')) as YearMonth,"
I get this error:
Script(until now)
ODBC CONNECT32 TO Spixx.com;
SQL SELECT `order_id`,
`user_id`,
Date(created) as created,
Day(created) as Day,
Month(created) as Month,
Year(created) as Year,
Dual(Month(created) & ' ' & Year(created),year(created) & num(month(created), '00')) as YearMonth,
`product_id`,
`currency_id`,
amount,
`count`,
first
FROM bi.`business_intelligence_spigo_order`;
If you remove that line it will load just fine?
Hi,
There is no function like Dual in sql script. So only its show error..
Try like this:
Load
user_id,
Date(created) as created,
Day(created) as Day,
Month(created) as Month,
Year(created) as Year,
Dual(Month(created) & ' ' & Year(created),year(created) & num(month(created), '00')) as YearMonth,
product_id,
currency_id,
amount,
count,
first;
SQL SELECT order_id,
user_id,
Date(created) as created,
product_id,
currency_id,
amount,
count,
first
FROM bi.`business_intelligence_spigo_order`;
Hope it helps
Hi,
There is no function like Dual in sql script. So only its show error..
Try like this:
Load
user_id,
Date(created) as created,
Day(created) as Day,
Month(created) as Month,
Year(created) as Year,
Dual(Month(created) & ' ' & Year(created),year(created) & num(month(created), '00')) as YearMonth,
product_id,
currency_id,
amount,
count,
first;
SQL SELECT order_id,
user_id,
Date(created) as created,
product_id,
currency_id,
amount,
count,
first
FROM bi.`business_intelligence_spigo_order`;
Hope it helps
what do you mean there are no dual in sql script?
I throught "dual" were a qlikview function - How do I solved this?
aaaah, I understand now
Thank everything works now 🙂