Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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