5 Replies Latest reply on Dec 4, 2008 4:41 PM by user2657915

    conditional mapping in mapping tables

      I need to map a group of source accounts to different target accounts based on the category in the POV and a couple entities to different targets based on period and category in the POV. I do not want to set up separate mapping table/locations for every entity for the different years/periods or change the mapping tables every time data is reloaded as it increases the likelihood of error.

      I should be able to use "#script" in the target field and write a script to handle the mapping, but have not had any luck.

      Has anyone used "#script" in mapping tables?