Multi Period Planning to HFM: # is not recognized
Hit Expert,
I have a location EPM to EPM (Planning to HFM). For exporting budget all months, the export from planning bring this line of data:
"PLANT_NONE","PA_NONG","RS11","PFS_NONE","BIBIG090","DEST_NONE","V_TAUX","FY17","BUDGET","LOC","COEFF","NAT_NONE","YTD",#,#,#,#,#,#,#,#,#,#,#,54.
For this example, the data is on December only, but this line of data is not accepted by FDMEE: The # is not a numeric character.
[TC] - [Amount=NN] "PLANT_NONE","PA_NONG","RS11","PFS_NONE","BIBIG090","DEST_NONE","V_TAUX","FY17","BUDGET","LOC","COEFF","NAT_NONE","YTD",#,#,#,#,#,#,#,#,#,#,#,54
Do you have an idea to resolve it, without using a script (befImport to clean data) please.