Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Amit_B
Creator II
Creator II

Save file's text in a variable

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)

Labels (2)
2 Replies
Or
MVP
MVP

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.

Kianbruce
Contributor
Contributor

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