Error when loading tables in Qlik Sense

[carpentiere]

Hi,

I'm new to Sense Desktop and begin to recreate QlikView Documents to QlikSense.

I don't encounter any difficulty, except for some tables i have in my database :

if i do that :

LOAD "timestamp",

    Code,

    Nom,

    Fournisseur;

SQL SELECT "timestamp",

    Code,

    Nom,

    Fournisseur

FROM FL2Clovis.dbo."CARPENTIERE FRANCE$Assurance crédit";

It is OK, no error :

if i do that :

LOAD "timestamp",

    "N° client",

    "Code assurance",

    "Date début",

    "Date fin",

    Montant,

    "N° contrat",

    "Bloqué",

    Cascadable,

    Doublon;

SQL SELECT "timestamp",

    "N° client",

    "Code assurance",

    "Date début",

    "Date fin",

    Montant,

    "N° contrat",

    "Bloqué",

    Cascadable,

    Doublon

FROM FL2Clovis.dbo."CARPENTIERE FRANCE$Assurance crédit orig (tmp)";

I got this error :

Connector reply error: SQL##f - SqlState: 37000, ErrorCode: 102, ErrorMsg: [Microsoft][SQL Server Native Client 11.0][SQL Server]Syntaxe incorrecte vers '/'.

It happens for all tables which have an '('..')' in the name.

This doesn't appear when i use QlikView.

I cannot change the name because thess tables are ERP tables.

Does anyone have an idea to solve this point ?

Thanks,

[jaimeaguilar]

Hi,

it may be some incompatibility issue with some characters. Have you tried extracting data through ODBC instead of OLEDB? also you can try the "Microsoft OLE DB Provider for SQL Server" instead of the Native client,

hope this helps

best regards

[carpentiere]

Hi,

Thanks a lot for your fast answer.

This is not due to Provider, i tried with all the SQL Provider.

Finally, it is due to Qlik Sense interpretor :

I use

FROM FL2Clovis.dbo.[CARPENTIERE FRANCE$Assurance crédit orig (tmp)] ;

(replace " by [ and ] " and it works with all the different Provider).

Best regards.