How to pick one value from column as variable

qs123 — Sat, 16 Nov 2024 04:31:22 GMT

Hi Team,

I have one .txt file which only contains one word. I want the Qlik load script to pick that one word as variable.

A third party system is generating a .TXT file and placing it in a fixed location.
This file only contains 1 word. this word gets updated and overwritten every 6 hours.
We need to pass that word as a filter in expression as set analysis.

How can Qlik load script pick that word and store it as variable?

So that we can use that variable in set analysis

Thank you

Re: How to pick one value from column as variable

NZFei — Tue, 01 Oct 2019 00:15:20 GMT

FileValue:
LOAD
@1 as WhateverName
FROM
[C:\FilePath\file.txt]
(txt, codepage is 1252, no labels, delimiter is '\t', msq);

let vVariable = peek('WhateverName',-1,'FileValue');