How to load HFM data with Year and Period in multiple rows to FCC ?
Summary:
I’m trying to figure out how I can load data from HFM to FCC.
Content (please ensure you mask any confidential information):
The HFM extract comes in this format:
!DATA
Actual; 2025; Jan; YTD; ATE; DKK; 76000; IGE; [None]; [None]; ERP; [None]; -140
Actual; 2025; Feb; YTD; ATE; DKK; 76000; IGE; [None]; [None]; ERP; [None]; -447
Actual; 2025; Mar; YTD; ATE; DKK; 76000; IGE; [None]; [None]; ERP; [None]; -1123
What would be the best approach to have Data Management to look at the second and third column (e.g. 2025: Jan) and transform this into FCC format (FY25; Jan) for multiple columns with Period varying through rows?