Forum Discussion
Load& Combine + Unpivot
hi Team, i have monthly excel files that contains a forecast for some items, each item has a code and descrition. the table i recieve monthly contain first column called "code", second column ca...
camargos88 thanks but it gives me the below result. for each source
however, souce 1 contains values from 1 May20 till 1 Mar21, and source 2 contains values from 1 June20 till 1 April21.
kindly referring again to the combined view in my post as the required output (red cells means month column should apear with a zero value).
camargos88
Community Champion
Community ChampionHi ahmadhlawa ,
Have you checked the file ?
I've created this scenario with 3 files, when it doesn't have dates, it's null (can be replaced to 0).