How to store Data into a table box from two sources in one table

[phb_nostromo]

That code : ( inspired from Qlik Community thanks ) :

LET vStartDate = MakeDate(2017, 1, 1);
LET vEndDate = MakeDate(num(year(Today())), 12, 31); 
LET vNumberOfDays = vEndDate - vStartDate + 1; 

TableCroisee:
load ADV from [$(vs_Qvd)BaseSHP_ADV0.qvd] (qvd);
load
year(Date(makedate(2017)+recno()-1))*100 + week(Date(makedate(2017)+recno()-1)) as AnSem
AutoGenerate $(vNumberOfDays);

Gives me that table :

Under two sources :

What shoud i add to be able to store the result in only one table ?

Thanks a million

[tamilarasu]

I am clear on that now . So you need only week numbers and the corresponding year i.e 54 (2017) + 54 (2017) = 208 weeks in this case. The first code will produce duplicate year week numbers. So the second script is the one you are looking for. Have a super day, Philippe!