Skip to Main Content

FDMEE using Year and Period separetely in Period Mapping

AngeloAereJul 29 2022

I'm having some problems mapping the periods for my FDMEE load.
My source file contain Year and Month, using the example as format: M05, FY22
image.pngMy global mapping:
image.pngI know that i need to make a source mapping, but, as my source file comes with FY22, i try to map with that and get the following error:
image.pngIs there a way to get this to work with the source file coming with FY22 format instead of only numbers?
Maybe i should use some kind of value mapping to transform FY22 to 2022? What should i do?