How to use Qlik num() or num#() function, in SQL Select properly?

[mrichman]

Hi Community,

I have been trying to use number format one of my data field, however I'm getting an error on this the whole time. Would be nice if you could help, thanks in advance!

Error:

SQL##f - SqlState: 37000, ErrorCode: 4294964196, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Num(["Data"],'############')'.

Script Example:

SQL SELECT

    Num(["Data"],'############') as Data1,

    Data2

FROM "MasterData";

[mrichman]

Vijay,

Thanks for you help, it is already solved by:

Load

    Num(Num#(Data)) as Data1,

    Data2;

SQL SELECT

    Data,

    Data2

FROM "MasterData";

[Anonymous]

welcome, ... so your number was not a number

[mrichman]

Yes you are right, the dataset is quite toxic. It is a mix of numbers and texts but number format is leading. Do you have any other suggestions?