topic Re: Loading Binary File into Qlik in Connectivity & Data Prep

Loading Binary File into Qlik

anushree1 — Fri, 02 Apr 2021 08:55:33 GMT

Hi,

I have a requirement wherein the data is extracted via SFTP and copied to a Folder and this data is a Binary File , so we need to convert it to Excel and then load it to qlikview

I have heard we can use Sharepoint Connector, but then again the load of a Binary File to qlik cannot be done directly , so how do we go about this situation?

Please suggest

@vegard , @kaushiknsolanki

Re: Loading Binary File into Qlik

kaushiknsolanki — Fri, 08 May 2020 11:46:49 GMT

Hi,

You can not directly load binary file like normal excel in Qlik.

You have to either convert into excel or use any ODBC connection and then you can use that in Qlik.

Re: Loading Binary File into Qlik

anushree1 — Fri, 08 May 2020 11:51:05 GMT

Sure , but I am hoping to use a sharepoint connector to get the data so how in this case can i as well use a odbc connection?