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
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).
camargos88 your file looks fine, but i don't have the sources on my PC, so can't trace the steps.
do you do those steps to the sample file (from your screen shot i can't see the "Source name" column)?
what i tried is, first i combine all files, then unpivot them, then put the functions you mentioned.
if you do it to the sample file can you please elaborate how can i do that?