Hi,
I have a multi-period data load from PBCS to HFM which returns type conversion exceptions for rows whitch have # in columns with missing/no data. What can I do about these exceptions? Since it is basically missing data nothing should actually be transferred anyway but I was wondering whether I could somehow set FDMEE to ignore such rows rather than throw these exceptions
[TC] - [Amount=NN] "HSP_InputValue","Add YTD","ICP_None","MAK","FY18","Local","Draft","FCST","BS212500",#,#,#,#,#,#,53000,60500,60500,60500,60500,60500
[TC] - [Amount=NN] "HSP_InputValue","Add YTD","ICP_None","RFK","FY18","Local","Draft","FCST","BS213500",#,#,#,780.46,780.46,780.46,780.46,14060.46,17060.46,17060.46,17060.46,17060.46
[TC] - [Amount=NN] "HSP_InputValue","Add YTD","ICP_None","RFK","FY18","Local","Draft","FCST","BS220500",#,#,#,#,150600,150600,150600,458088,458088,458088,458088,458088
[TC] - [Amount=NN] "HSP_InputValue","Add YTD","ICP_None","UKF","FY18","Local","Draft","FCST","BS210500",#,#,#,#,#,#,124508.48,124508.48,309508.48,309508.48,309508.48,309508.48
[TC] - [Amount=NN] "HSP_InputValue","Add YTD","ICP_None","PRK","FY18","Local","Draft","FCST","BS210500",#,#,#,#,#,16340,16340,18212,18212,18212,18212,18212
[TC] - [Amount=NN] "HSP_InputValue","Add YTD","ICP_None","PRK","FY18","Local","Draft","FCST","BS220500",#,#,#,350000,550000,550000,3898637,4599517,4599517,4749517,4749517,4749517
[TC] - [Amount=NN] "HSP_InputValue","Add YTD","ICP_None","KUR","FY18","Local","Draft","FCST","BS210500",#,#,#,#,#,#,19245,90441,90441,90441,90441,90441