Extracting data from a Navision 3.56 native database

Thu, 13 Oct 2011 07:34:24 GMT

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

Extracting data from a Navision 3.56 native database

Wed, 23 Nov 2011 11:41:09 GMT

Try this:

[Sold-To Customer No.] as Customer

topic Extracting data from a Navision 3.56 native database in QlikView

Extracting data from a Navision 3.56 native database

Extracting data from a Navision 3.56 native database