calendar problem

[#1]

I want to know  if we are having different calendars like

• we have month , year in table1
• The whole calendar in table2 in which some values are missing  because on those days were holidays or no sale data
• There is also target year in table3

How we can map all of them to one calendar without any loop creation.

[SunilChauhan]

use concatenate to combine into one

tab 1

concatenate

tab 2

concatenate

tab 3