topic import excel file with using variable in QlikView

import excel file with using variable

marlku1234 — Wed, 25 Nov 2020 16:16:04 GMT

set vFilePath = 'Z:\work\Spreadsheets\',

LOAD [ Code],

MSCode,

[First File Date]

from

$(vFilePath)'ATT UNL Maps.xlsx'

(ooxml, embedded labels, table is [Date Map]);

somehow its not working

tamilarasu — Wed, 17 Jan 2018 02:41:08 GMT

Hi Ujjwal,

Set vFilePath = 'Z:\work\Spreadsheets\';

LOAD [ Code],

MSCode,

[First File Date]

from

$(vFilePath)ATT UNL Maps.xlsx

(ooxml, embedded labels, table is [Date Map]);