topic Loading This Sample Data in QlikView

Loading This Sample Data

Anonymous — Wed, 23 Aug 2017 05:49:18 GMT

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.

Re: Loading This Sample Data

micheledenardi — Wed, 23 Aug 2017 07:02:51 GMT

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

Re: Loading This Sample Data

danistontt — Wed, 23 Aug 2017 08:43:20 GMT

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