Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-03-20 09:47 AM

Load from FTP works in version 11, gets unknown load error in version 12

We are upgrading from version 11 to 12 and I am testing all the loads in an upgraded (12.20 SR3) copy of our test environment.  One of the loads pulls change log files from the SAP server.  It is working in our current production and test but is failing using QlikView 12.2 SR3.

The load step is fairly simple:

LogisticsChg:
LOAD *
FROM
[ftp://AcctName:Password@SAPServerName.ent.Entity.com/interfaces/SD/out/bel/Logistics_Chg_JAN-JUNE_20...Password@SAPServerName.ent.Entity.com/interfaces/SD/out/bel/Logistics_Chg_JAN-JUNE_2018.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

 

but gets this error in version 12

Error: Unknown LOAD statment error

Unknown LOAD statment error

Does anyone know what changes for FTP extracts are required in version 12 of QlikView?

-John

423 Views
0 Likes
0 Replies
Community Browser