Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Loading multiple year data

Good Day

As you will note from my question, I have just started using Qlik Sense. How do I load data that is exactly the same in terms of tables headings for 2 different years?  In other words I am loading data from an excel sheet with various tables (eg A-Z) (which has been exported from my database) for the 2014 year.  And I am also wanting to load exactly the same tables (A-Z) for the 2013 financial year.

Your assistance is appreciated.

Kind regards

Ronelle

3 Replies

Re: Loading multiple year data

If your data have only one common field they will be link be that field.

But please post your data to see what they look like

ogster1974
Honored Contributor II

Re: Loading multiple year data

Concatenate your source tables into one.

Example attached

concatenate two tables

kevincase
Contributor II

Re: Loading multiple year data

Ronelle,

I am making an assumption that you have two Excel files with multiple sheets and that there are 'keys' on each sheet to tie your data together.  Without sample data, we are just guessing.  If your question is how to loop through the excel spreadsheets then it can be accomplished pretty easily.  Take for example the following two Excel files,

MyData_FY2013.xlsx

MyData_FY2014.xlsx

Notice the file names.  Same name except for the 3 and 4.

Each files has multiple sheets and each sheet has the same data fields.  You can do something like the following to load the data from sheet1 from both files.

Sheet1Data:

LOAD

    Field1,

    Field2,

    Field3

FROM [lib://MyDataFolder/MyData_FY201*.xlsx]

(ooxml, embedded labels, table is Sheet1);

Since the file names are similar, you can use an * in the file name and Qlik will process all files in the specified directory based on the wildcard.

This same process can be used for each sheet in the workbook.

Hope this is what you were looking for.

Kevin