topic SET csv file as variable in QlikView

SET csv file as variable

QlickySense — Thu, 30 Sep 2021 12:50:16 GMT

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 — Thu, 30 Sep 2021 13:20:49 GMT

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 — Thu, 30 Sep 2021 13:39:57 GMT

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