Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Extracting data from a Navision 3.56 native database

Hi!
I'm trying to import data in to Qlikview from a Navision 3.56 native database. I have a problem with some of the field names ending with a dot eg.:
"Sales order no.". When I try to import this field Qlikview is stalling. Does anyone have an idea how to avoid problems when importing such data? I'm using an ODBC connection to access the database. See example below:
ODBC CONNECT TO Navision (XUserId is TOOCYaZMKTUB, XPassword is XDZGJWVMOLZEB);
SQL SELECT
"Amt. Incl. Sales Tax",
"Department Code",
Description,
"Line Discount Amount",
Quantity,
"Sold-To Customer No.", THIS LINE IS CAUSING
"Unit Cost ($)"
FROM "Sales Invoice Line";
Thanks!
Henrik
1 Reply
Not applicable

Extracting data from a Navision 3.56 native database

Try this:

[Sold-To Customer No.] as Customer

Community Browser