Join/Append 2 Lists

Hi team,

 

This is an usual question but I have 2 lists (1 customer & 1 future revenue to be derived off future sales) which I want to append into 1 Phantom/Clone list where I can then Lookup the values from 2 modules & review/analysis the data in 1 module

 

Is there any methodology to create such a list?

 

Thanks

 

Mark 

Tagged:

Best Answers

  • Hi @MarkTurkenburg 

     

    Do see if the following works:

    1. Customer Sales is a module with 1 list, i.e. 'Customer'; Fake Time Sales is a module with 1 list, i.e. 'Fake Time'.

    Select Customer/Fake Time is a module with 1 list, i.e. Customer/Fake Time. This is where you either select a 'Customer' or a 'Fake Time', the selection is shown in 'Final Selection', and Sales will grab from 'Customer Sales' or 'Fake Time Sales'.

    Screen Shot 2020-01-25 at 17.00.42.png

    2. Customer/Fake Time is a numbered list which grab 1 selection from 'Select Customer/Fake Time' as Display Name.

    Screen Shot 2020-01-25 at 17.01.18.png

     

    3. Blueprint of 'Select Customer/Fake Time'.

    Screen Shot 2020-01-25 at 17.03.03.png

    Screen Shot 2020-01-25 at 17.03.30.pngScreen Shot 2020-01-25 at 17.03.45.png

     

    Thanks,

    LipChean

     

  • Hi @MarkTurkenburg 

     

    The modification i suggest below assumes you're inserting 'Customer' and 'Fake Time' manually in the model. If you're loading 'Customer' and 'Fake Time' from Data Hub or via Anaplan Connect, then you can just run a process (with 3 actions) that inserts 'Customer', 'Fake Time' and 'Customer/Fake Time'. Essentially you're adding new members in all 3 lists, so that the same 'Customer A' is created in both 'Customer' and 'Customer/Fake Time'.

     

    Do see if the following work:

    1. I've added 'Count' line item in all 3 modules.

    Screen Shot 2020-01-26 at 09.06.41.png

    2. A new module that compares the number of 'Customer/Fake Time' against 'Customer' + 'Fake Time' is created.

    Screen Shot 2020-01-26 at 09.09.25.png

    3. In the dashboard, you can check if 'Load Customer/Fake Time?' is true or not, if it is then you can click on 'Add Customer/Fake Time' process.

    Screen Shot 2020-01-26 at 09.09.31.png

    3. The process is made up of 2 actions, one of which is the creation of 'Customer/Fake Time' list from 'Customer' list. The 2nd action is the creation of 'Customer/Fake Time' list from 'Fake Time' list.

    Screen Shot 2020-01-26 at 09.15.19.png

     

    Thanks,

    LipChean

Answers

  • Hi Mark,

     

    Can you give more context and illustration of the requirement. Is it just brining data from 2 lists into 1 combined list, also will the scenario include duplicates in the 2 source lists.

     

    Thanks

    Arun

  • Hi @ArunManickam 

     

    There a 2 different lists, 1 is numbered and 1 is standard. They are used in different modules to to calculate revenue from different sources

     

    I need to combine them so i can bring data from both source modules & review them in 1 module

     

    There are 2 duplicates

     

    Let me know if this is not clear

     

    Thanks!

     

    Mark

  • Hi @MarkTurkenburg ,

     

    Can you give some screenshots, the issue is still not clear.

     

    Thanks,

    Yash

  • Thanks @AlejandroGomez  for the detailed reply, it is a great example for that use case but unfortunately I was not clear enough in my original post & I'm not trying to combine to lists (e.g. List item 1 from List A & List item 1 from List B to become List item 1 & A in List 3) but to create a list which has each item from the 2 original lists into a new list. Let me explain further by example:

     

    We have a #Customer Account list & an #Alternate Time Period list. Both lists are used in separate modules to forecast revenue for future periods.

    #Customer Account list is used for current customer forecasts &

    #Alternate Time Period is used to determine revenue from future sales that are not allocated to a specific customer account

     

    I wish to create a module whereby I can view the revenue from all the list items in both lists in 1 module. My thought was I could create a #Customer Account & Alt Time Period list whereby each item from both lists is in the list with a property that links it to the original list, thereby allowing me to view revenue from both lists within 1 view

     

     

    #Customer Account List

    #Customer Account List.PNG

    #Alternate Time Period list

     

    #Alternate Time Period List.PNG

     

    Example of Joined list

    Joined List.PNG

     

       

  • @LipChean_Soh , good explanation. Also will it help in the third list (composite list) to have all the customer as parent and adding the required fake time as child. In this way you could still get an aggregation of total revenue by customer. Moreover, if required we could still have more time range to a particular customer using the child list (numbered list).   

  • Hi @Asslam 

     

    As you can see from the 'Example of Joined List' provided by @MarkTurkenburg , the member in the 3rd list is either from the 1st list OR from the 2nd list.

     

    Unless i'm mistaken, there's no parent child relationship between Customer and Fake Time.

     

    Thanks,

    LipChean

  • Thanks @LipChean_Soh  for the detailed response, it works quite well

     

    The main issue I was having trouble with was creating a method whereby the Customer/Fake Time list could be updated automatically by an Action. In your example I believe I would do the following to create the Customer? & Fake Time? line item values

     

    1) Create a module with the #Customer Account as the dimension and return the List value as the line item. Then copy all the values & paste into the Customer? line item

    2) Repeat the same for the #alternate Time Period into the Fake Time? line item

     

    MarkT83_0-1579981025734.png

     

    This works fine but is not dynamic & requires the manual work around of copy/paste. Are you aware of any method whereby I could return values to the Customer? & Fake Time? line items via an Action?

     

    Many thanks

  • Thanks @LipChean_Soh  - fantastic solutions!

     

    Mark