topic Re: Error command which worked with table files in QlikView

Error command which worked with table files

Wed, 11 Jul 2012 14:07:27 GMT

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?

Re: Error command which worked with table files

MayilVahanan — Wed, 11 Jul 2012 14:26:01 GMT

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

Re: Error command which worked with table files

Wed, 11 Jul 2012 14:37:02 GMT

what do you mean there are no dual in sql script?

I throught "dual" were a qlikview function - How do I solved this?

Re: Error command which worked with table files

Wed, 11 Jul 2012 19:23:59 GMT

aaaah, I understand now

Thank everything works now 🙂