Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marlku1234
Contributor II
Contributor II

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

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

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
tamilarasu
Champion
Champion

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