How can i get whole data from Secondary data source using data Blending.

Hello Experts,

I am working on Tableau for the past one year and have a requirement like below.

I have 2 data sources , Primary a HANA View and the Secondary an Alteryx flow.

Primary source has Year from 2018 to 2023 and the Secondary from 2018 to 2030.

I have blended the data using common fields Year and Market.

After blending i see data only from 2018 to 2023 in the chart.

Is there a way where i can create a graph that shows data from 2018 to 2030 i.e. All years from Secondary source.

Any suggestions would be greatly appreciated.

Thanks

Kumar