topic Re: Loading textfile into field? in QlikView

Loading textfile into field?

Amphan — Mon, 19 Jan 2015 14:17:02 GMT

Hi,

Is it possible to load a complete textfile into a field? I have a folder with textfiles (unstructured data) and would like to load each textfile into a field, not line by line, but the full textfile, from start to end of file. Is there any limitation on how long a string in a field can be? Some of the textfiles is several megabytes in size.

Grateful for any input!

TIA

Ola

Re: Loading textfile into field?

alexandros17 — Mon, 19 Jan 2015 14:43:57 GMT

It is not reccomanded, performances decrease, use a text box instead and fill it only when user select one row.

In these cases the best is to use "Direct Discovery" ... look for it

Hope this helps

Re: Loading textfile into field?

stigchel — Mon, 19 Jan 2015 15:07:07 GMT

The real question here is, why should you want to do this?? If it is a simple matter of being able to look at the text file, simply host the files somewhere and include a link in QlikView which will open/download the file. Should you want to interact with the contents, e.g. search the text, there seems no reason not to load line by line.

Also instead of lines of text, consider splitting it even further up by word. The following is some load script I use to create a word cloud.

O_file:

crosstable(OpenQuestions,Verbatim,2)

LOAD @1:8T as ID,

@1:8T&@13:17 as QID,

if(@13:17='Question 1',@20:n) as Question_1

FROM Data.txt(ansi, fix, no labels, header is 0, record is line);

Words:

LOAD QID, mapsubstring('TextMap',subfield(capitalize(keepchar(upper(Verbatim),'ABCDEFGHIJKLMNOPQRSTUVWXYZ ')),' ')) as Word

RESIDENT O_file;

INNER JOIN (Words)

LOAD QID, Word

RESIDENT Words;

Re: Loading textfile into field?

Wed, 24 Feb 2016 20:26:59 GMT

I have a similar problem. Why am I loading text data from SQL into Qlik Sense?

Because I am trying to incorporate help text on a separate Qlik Sense Sheet for new users to understand and consume the information in the dashboards.
These are mostly new individuals to our organization.

Other than entering a limited text to each sheet, is there any way to provide context sensitive help to a Qlik Sense Application or Sheet?

Re: Loading textfile into field?

deepti_singh — Thu, 08 Nov 2018 14:41:54 GMT

Hi Sylvia,

I am looking for a similar requirement in Qlik Sense, where the contents of a text file need to be shown in the text box in front end and this content is updated regularly so the process should be as dynamic as possible.

Did you find a solution to this?

Thanks.

Deepti