Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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');