Concatenate 2 tables

[siem]

Hello, I got this script : 

STOCK:
Qualify *;
Unqualify [ID ARTICLE];
LOAD
Date_Stock,
"No Magasin",
"Code Article" as [ID ARTICLE],
"Stock Total",
"Stock Dispo",
"Stock Transit"
FROM [lib://Google_Drive - Stocks_2019.xlsx];

LOAD
Date_Stock,
"No Magasin",
"Code Article" as [ID ARTICLE],
"Stock Total",
"Stock Dispo",
"Stock Transit"

FROM [lib://Google_Drive - Stocks_2020.xlsx];

unqualify *;

When I execute script, i got 2 distinct tables.

I would like to have just 1 table with 6 field.

Thanks in advance

[MayilVahanan]

Hi

Try like below

LOAD
Date_Stock as Stock.Date_Stock,
"No Magasin" as Stock.NoMagasin,
"Code Article" as [ID ARTICLE],
"Stock Total" as Stock.Total,
"Stock Dispo" as Stock.Dispo,
"Stock Transit" as Stock.Transit
FROM [lib://Google_Drive - Stocks_*.xlsx];

Or
If you have more fields and difficult to change manually, try like below

STOCK_Temp:
LOAD
Date_Stock,
"No Magasin",
"Code Article" as [ID ARTICLE],
"Stock Total",
"Stock Dispo",
"Stock Transit"
FROM [lib://Google_Drive - Stocks_*.xlsx];

Qualify *;
Unqualify [ID ARTICLE];
Stock:
Load * resident STOCK_Temp;
unqualify *;

Drop table STOCK_Temp;