topic Save file's text in a variable in QlikView

Save file's text in a variable

Amit_B — Mon, 21 Aug 2023 13:12:25 GMT

Hey,

I need to save in the QV model (on the server) a variable that contain the content of a Word file (saved on a local computer).
The content of the file can change, it is about a few lines.
The document editor does not have access to the server or the model.

how can I do that? (by script or GUI)

Re: Save file's text in a variable

Or — Mon, 21 Aug 2023 13:18:48 GMT

Load the contents of the file normally, and then use

Let vMyVariable = Peek('YourFieldNameHere');

Do note that, afaik, you can't read Word documents as data into Qlik, so you'll want to save it as txt, csv, or otherwise a format that Qlik can read.

Re: Save file's text in a variable

Kianbruce — Fri, 25 Aug 2023 11:42:25 GMT

Share File: Make the Word file accessible to the QlikView server. One method is to share the file on the network. QV Load Script: In your QlikView application, use a LOAD script to read the content of the Word file. You can utilize the QlikView's COM functions or use a third-party tool to convert the Word content into a format QV can directly load, like plain text or CSV