This content has been marked as final. Show 6 replies
May be like this..
CrossLoad your Table, Then use the Mapsupstring function to replace the value.. Like
T1: CrossTable(YearMonth, Data) LOAD GLAccount, Balance_CurrYr_Jan, Balance_CurrYr_Feb, Balance_CurrYr_Mar, Balance_CurrYr_Apr, Balance_CurrYr_May, ...... .... From Source;
After Cross Load..
MAPField: Mapping LOAD * INLINE [ F1, F2 Balance_CurrYr_, 2015 Balance_PriorYr1_, 2014 Balance_PriorYr2_, 2013 Balance_PriorYr3_, 2012 ]; T2: LOAD GLAccount,Data,MonthName(Date#(Left(MapSubstring ('MAPField', YearMonth),7),'YYYYMMM')) as MonthYear Resident T1; DROP Table T1;
Check the Attachment. May be helps..