Join/Append 2 Lists

LipChean_Soh
Certified Master Anaplanner

Re: Join/Append 2 Lists

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

View solution in original post

MarkTurkenburg
Community Boss

Re: Join/Append 2 Lists

Thanks @LipChean_Soh  - fantastic solutions!

 

Mark