Adding a column to each sheet with the name of the sheet

[JustTryingToLearn]

Hi,

I am trying to build a dashboard in Qlik Sense. My data comes from many different sheets that are similar to each other. I want to bring the data in an concatenate it, but I also want to know what sheet the data come from. I think the best way to do this is by adding a field to each sheet as I bring it in, and then populate that with the name of the sheet for every row. Only problem is, I don't know how to do this. 

Can someone help me with this? Is there a better way to do this? 

[JordyWegman]

Hi,

You can create a variable that contains the name of the sheet like this:

let vSheetName = 'Sheet1';

Load
    Field1,
    Field2,
    '$(vSheetName)' as _indSection
From [YourSource]
;

We often use _indSection to name the column that separates sections in your table.

Jordy

Climber