Error command which worked with table files

[#1]

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?

[MayilVahanan · Accepted solution]

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

[#3]

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

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

[#4]

aaaah, I understand now

Thank everything works now 🙂