topic Re: How to fetch Flat file(.CSV,Excel) from different server to Qlikview Server in QlikView

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

Anonymous — Thu, 16 Mar 2017 11:07:31 GMT

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.

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

rahulpawarb — Thu, 16 Mar 2017 11:17:18 GMT

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

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

Anonymous — Thu, 16 Mar 2017 11:38:53 GMT

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?

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

rahulpawarb — Thu, 16 Mar 2017 12:03:55 GMT

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

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

Anonymous — Thu, 16 Mar 2017 12:36:14 GMT

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.

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

rahulpawarb — Fri, 17 Mar 2017 05:16:31 GMT

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

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

mfchmielowski — Fri, 17 Mar 2017 09:25:25 GMT

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

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

Anonymous — Wed, 22 Mar 2017 09:25:37 GMT

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?

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

Anonymous — Wed, 22 Mar 2017 10:59:17 GMT

Hi Community,

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

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

mfchmielowski — Wed, 22 Mar 2017 11:50:35 GMT

Sample code:

Table:

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

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