source name in concat

[Louveduval]

Hello,

I'm sorry to bother you , I have concatenated 10 tables but I would like to have a column with the name of the source.

LOAD Id_kpi_article_depot,
Cle_article_depot,
Code_article,
Code_depot,
Libelle_depot;

[CO002_KPI_ARTICLES_DEPOTS]:
SELECT "Id_kpi_article_depot",
"Cle_article_depot",
"Code_article",
"Code_depot",
"Libelle_depot",

sources name 

FROM "Data_Coops".dbo."CO002_KPI_ARTICLES_DEPOTS";

Concatenate

[CO004_KPI_ARTICLES_DEPOTS]:
SELECT "Id_kpi_article_depot",
"Cle_article_depot",
"Code_article",
"Code_depot",
"Libelle_depot"

FROM "Data_Coops".dbo."CO004_KPI_ARTICLES_DEPOTS";

[marcus_sommer · Accepted solution]

If the tables contain an appropriate information you could just add it to the load (by loading from flat-file you could use something like filebasename() but I'm not sure if your data-base has a similar function) - otherwise you could simply add it manually, like:

'CO0002' as "Source"
respectively 
'CO0004' as "Source"