Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
SET DataTABLE = [Data.xlsx] (ooxml, embedded labels, table is [Data]);
It let me have DataTable with the path to the Data.xlsx file, then when I load some field I just use From $(DataTABLE);
I would like to SET csv file this way, but it doesnt work for me, I got errors
SET DataTABLE = [Data.csv] (txt, codepage is 28591, embedded labels, delimiter is ' , ', msq);
Any ideas?
Your issue is probably the quotes in the [delimiter is ','] section. Have a look at https://qlikviewcookbook.com/2018/01/let-set-quotes/
Try something like this,
SET DataTABLE = '[Data.csv] (txt, codepage is 28591, embedded labels, delimiter is '&Chr(39)&','&Chr(39)&', msq)';
Use it like this,
LOAD *
FROM $(DataTABLE)
;