Solved: import excel file with using variable - Qlik Community - 1794

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services | Qlik Help

Ask a Question

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

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

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