Generate month and year fields for a data set that don't contain date fields
I have create an app using qlik sense. The source data is excel files and every file represent one month. So I get every month an excel file to load it. All the files have the same structure, so I use the following approach:
Table: Load A, B, C, D, FROM [lib://AttachedFiles/Jan2019.xlsx] (ooxml, embedded labels, table is Sheet1);
Concatenate Load A, B, C, D, FROM [lib://AttachedFiles/Feb2019.xlsx] (ooxml, embedded labels, table is Sheet1);
How can I dedicate the month and the year while there is no field can be used as date.
I think it can be solve by generating a number field in every file and use it as month: