I have a source, derived column , Sink transformation in my data flow.
Derived Column transformation , I am getting some Year and Month from Source.
But I cannot see these(Year and month) column names in Sink settings tab when using file name option as pattern. But these column names are available in Optimize Tab of Sink.
I want file names as fact_combined_pnl_$Year_$Month in the $Year/$Month folder. Please check following screenshots
Attaching Derived Column Settings, Sink Settings and Expression Builder, Sink Optimize