06-01-2022
11:17 AM
- last edited on
05-02-2023
10:37 AM
by
JackLacava
HI All,
I am working on script to copy data from one channel member A to channel member B (New member), requirement here is to copy Actual, planning and forecast data. After data copy Member A become parent and Member B become children for Member A.
As per my knowledge this can be achieved with below mentioned options.
1. Right custom script copy data from Member A to Member B.
2. Export data from Member A and load back into Member B.
apart from this are there other ways like mentioned below.
1. What will happen if I rename Member A to Member B, is this work ? I mean data move from MemberA to Member B?
2. Post creating member B, is there any workaround to map Member A data to Member B by changing reference back end tables?
Thanks,
Sandeep
06-01-2022 05:18 PM
1. What will happen if I rename Member A to Member B, is this work ? I mean data move from MemberA to Member B?
This option works, renaming member a to member b will move the data as well
06-02-2022 01:17 PM
Technically speaking, renaming a member doesn't move data from old member to new. All data records will use Member IDs to reference cell intersections. As you rename a member, you're only updating the member name to an existing member ID.
Renaming a member from A to B and then creating a new Member A as a parent to B is the quickest way to achieve what you're looking for.
06-02-2022 01:24 PM
That's what happens technically at the background,
Putting it in a simple way its nothing but Member A data will be displayed for Member B going forward after the rename