Forum Stats

  • 3,814,696 Users
  • 2,258,899 Discussions
  • 7,892,808 Comments

Discussions

Is there any alternate to map one source member to two target members other than logic groups.

Answers

  • SH_INT
    SH_INT Member Posts: 3,192 Bronze Crown

    You can only map one record to one record so whatever you do will involve duplicating the original source record, which is essentially what Logic Groups do. My question would be what is prompting you to look for an alternative method?

  • User_99JQ1
    User_99JQ1 Member Posts: 2 Green Ribbon

    Because,'Logic groups' are only accepting a source account which has numeric data in it,but,what if we need to map a source account of 'text' data type to two targets accounts?

  • Stu G-Oracle
    Stu G-Oracle Member Posts: 43 Employee

    I haven't tried it but have you tried using a Logic Account with the Operator field set to Exp (expression) and then using CURVAL as the expression? The guide suggests does not state that this is a purely mathematical calculation so it might "copy" the value for you.

    If that doesn't work you may need to consider duplicating the record somehow in the source or using DATACOPY in the target once loaded (assuming you are loading to planning).

    Regards

    Stu

  • Paul Håvik
    Paul Håvik Member Posts: 29 Blue Ribbon

    logicaccount only work with numeric datatype....., so you can create an event that duplicates rows....only in FDMEE not clud.