How to fetch Flat file(.CSV,Excel) from different server to Qlikview Server

[Anonymous]

Hi Community,

I have to fetch flat file i mean .CSV file from different server to my qlikview server.

is it possible to fetch flat file from different server to qlikview server?

If yes then how to fetch data from different server to Qlikview server?

Thanks in advance.

[rahulpawarb]

Hello Ishwar,

If flat file on another server is accessible from QlikView server then please use below given script:

Data:
LOAD Id, 
     Name
FROM
[\\shareserver\Rahul Pawar\Data.xlsx]
(ooxml, embedded labels, table is Sheet1);

Hope this will be helpful.

Regards!

Rahul

[Anonymous]

Hi Rahul,

Thanks for your quick reply.

But can you tell me one thing how to fetch flat file from another server to qlikview server?

[rahulpawarb]

Hello Ishwar,

In similar fashion, you can extract the data from .csv file located on different server into QlikView server.

NewData:
LOAD Country, 
     [Alpha-2 code], 
     [Alpha-3 code], 
     [Numeric code], 
     [Latitude (average)], 
     [Longitude (average)]
FROM
[\\shareserver\Rahul Pawar\Country_List_ISO_3166_Codes_Latitude_Longitude.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);

Hope this will be helpful.

Regards!

Rahul

[Anonymous]

Hi Rahul,

I am not fetching data of .CSV file. I have to fetch all .CSV file which is located in another server to my qlikview server.

[rahulpawarb]

Hello Ishwar,

To achieve the same you have to prepare a batch file with below command:

//Syntax: copy <Source> <Target>
copy "\\192.168.1.1\\Rahul Pawar\*.csv" e:\Test\

Hope this will be helpful.

Regards!

Rahul

[mfchmielowski]

Hi.

If both servers are in one network area (LAN) you can use provided before example:

DATA:

load * FROM [\\remoteServerName\path\*.csv] (txt, utf8, embedded labels, delimiter is ',', msq);

Other way is to access files with ftp connection or even http request. Provide more information about localisation of remote server you need to access to fetch files

[Anonymous]

Hi Rahul,

I have refer your below thread in that you mention how to fetch flat file from ftp server to qlikview server.

How to fetch Files from an FTP Location?

We are doing this manually but same i have to do this automatic.

How i do this? 

[Anonymous]

Hi Community,

Any idea how to load .csv file from FTP server to Qlikview Server through automation code?

[mfchmielowski]

Sample code:

Table:

LOAD * FROM [ftp://LOGIN:PASSWORD@HOST/FILENAME.csv]

(txt, codepage is 1250, embedded labels, delimiter is ',', msq);