I have 5 excel files in which data is totally similar, just they all are generated in different months. For example, 1st excel file is generated in April, the second excel file is generated in May and soo on.
It can only be distinguished on the basis of the excel file name.
I have to concatenate (Mandatory) all these 5 excel files in Qlik Sense but I need a way to figure which data belongs to which month. Basically, I need to add a new dynamic column that tells which rows correspond to which excel file.
