extract sum of beneficiaries from specific table

[moteb_marei]

Hi,

If I have more than one table (one for shelter rehabilitation and other one for distribution and ..... so on)

and in the dashboard, I have concatenate them to give general overview. If 

I need to extract # of beneficiaries from specific one of them, how can I do that?

the path in the end of table in qliksense is like this :

FROM [lib://WASH_USER/syr_wash_assessments.xlsx]
(ooxml, embedded labels, table is syr_wash_assessments)

[Shubham_Deshmukh]

Let us know sample output and fields of your data, perhaps share sample data if possible

[moteb_marei]

the fields are same name for several tables that is the reason I couldn't able to extract for specific table.
data is only numbers of beneficiaries

[Shubham_Deshmukh]

Ok, I got it. You can maintain one more column specifies your each table.

Load A, B, 'tbl1' as C
from table1
concatenate
Load A,B,'tbl2' as C
From table2;

Now by putting condition ( C='tble1' OR C='tbl2') on 3rd derived column in expression, you can extract from specific table though you have concatenated them.