Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
marlku1234
New Contributor

import excel file with using variable

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

Tags (1)
1 Solution

Accepted Solutions

Re: import excel file with using variable

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

View solution in original post

1 Reply

Re: import excel file with using variable

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

View solution in original post