topic Load Data from Multiple Excel Files in a Folder from Qlik Replicate in Qlik Replicate

Load Data from Multiple Excel Files in a Folder from Qlik Replicate

davinci_rajesh — Mon, 13 Feb 2023 05:29:10 GMT

Well, I have multiple excel files in a folder and I want to load that data in qlik replicate and then replicate to target sql database. How can i do that?

Re: Load Data from Multiple Excel Files in a Folder from Qlik Replicate

john_wang — Mon, 13 Feb 2023 05:50:21 GMT

Hello @davinci_rajesh ,

Thanks for reaching out.

In general there are 2 approaches in Replicate to read records from files.

1. Configure the source file as regular ODBC DSN, and utilize the generic ODBC DSN to read the files; see more instructions about Using ODBC to connect to a source . (Qlik Replicate does not provide the ODBC driver, you may use other 3rd party 64-bit ODBC driver, or see below option 2.)

2. Configure Replicate to read the source file directly. Replicate supports delimited text files as a source in a replication task, more information can be found at Using a file as a source.

Hope this helps.

Regards,

John.

Re: Load Data from Multiple Excel Files in a Folder from Qlik Replicate

narendersarva — Tue, 14 Feb 2023 00:16:21 GMT

Hi @davinci_rajesh

Please refer below link for file source end point for excel files as source.

Using a file as a source | Qlik Replicate Help.

Thanks
Naren