SET csv file as variable

[QlickySense]

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?

[Or]

Your issue is probably the quotes in the [delimiter is ','] section. Have a look at https://qlikviewcookbook.com/2018/01/let-set-quotes/

[Saravanan_Desingh]

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)
;