Loading This Sample Data

[Anonymous]

Hi,

I have one sample excel file which I want to load in qlikview. It is just a sample for 1 year like that we have for 10 years then how should I proceed. please help me in that.

[micheledenardi]

If yours XLS contain the year in the file name (Ex. "2016 Sample Data" or "Sample Data 2016" or "Sample 2016 Data".....) you can extract the year directly from the file name by using FileBaseName() function:

LOAD
    left(FileBaseName(),4) as Year,
    if(len(trim(Clusters))>0,Clusters,peek(Clusters)) as Clusters,
    Country,
    US,
    EC,
    ....
   ....
FROM

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

[danistontt]

Hi Kaushal,

i think you can proceed with Crosstable Load for loading data from Excel.

For loading multiple file excel you can try these post:

Dynamically Loading Multiple Excel Files

Qlikview FOR EACH... Load Multiple Excel Sheets by RFB 200 - YouTube

Daniele