Forum Discussion

omaltby's avatar
omaltby
New Contributor II
4 years ago

Copying data from Two Entities into One

Hello,

Apologies if this seems like a rather basic question but I couldn't see anything in the Golfstream app.

Is there a standard business rule I can take which copies data from one POV into another and modify it so I can effectively combining two base entities into one? 

Thanks,

Oliver

Finance
  • Mustafa_A's avatar
    Mustafa_A
    Contributor II
    4 years ago

    Hi omaltby 

    We have a data management step that copies data from one entity to another.  You can create a "Copy Data" step - similar to this below. You can adjust your source/target scenario, time, view etc. accordingly. 

    I haven't tried copying from two entities into one. But I believe you will need to add both the source entities in "Source Entity Filter"  and your target entity in "Destination Entity"

     

    Hope this helps.

     

    Best,

     

    Mustafa A

     

     

     

     

  • omaltby's avatar
    omaltby
    New Contributor II
    4 years ago

    Hi Mustafa_A 

    Thanks for your reply.

    I tried following your suggestion but receive an error message when I set two source entities with one target (see below). As soon as I change it to one source entity to one target the copy is successful.

    Thanks,

    Oliver

    • Mustafa_A's avatar
      Mustafa_A
      Contributor II
      3 years ago

      Yep! I haven't tried it with two entitles before. I don't know if it'll work doing one entity at a time.

      I believe you can write a Seeding Rule in Finance BR to copy multiple entities. 

  • ckattookaran's avatar
    ckattookaran
    VIP
    3 years ago

    I'm not sure you can do this using copy data. Either you'll have to create a custom rule that does an accumulation or extract the data and use mapping and load it back. There could be another way, but I can't think of anything else.