Importing a list from Hub into Spoke Model

Hi Experts,

I have an import set for a list from data hub to my spoke model. My concern - the list items in the list on Data hub keeps changing based on the updates made in the upstream system. As an example say in Nov - I had the id ABCD1 as a list member in Data Hub and also in Spoke model when data was pulled.

Now in Dec - Upstream system decided that ABCD1 was an incorrect record and deleted it. My Data Hub list now no longer shows me ABCD1 as a list member. However my spoke model will continue to show it which is creating data inconsistencies between the models as the spoke model is holding old to now an invalid record. I dont see an option to Clear target prior to import the way we see in module imports.

How do I go about it? Please help.

Thank you,

Megha

Accepted answers

BrunoRodriguez

Hello @Megha27 ,

If I understand correctly, you have items in the spoke model that were originally imported from the hub , but do no longer exist.

Could you import a boolean that is true for all the items in the hub into a system module within the spoke model? The old items will be identified as false once the import arrives, so you can then create another boolean to drive a delete from list using selection action.

Hope that was helpful!

All comments

BrunoRodriguez

Hello @Megha27 ,

If I understand correctly, you have items in the spoke model that were originally imported from the hub , but do no longer exist.

Hope that was helpful!

Megha27

Hi @BrunoRodriguez ,

Thanks a ton! This helped me solve the issue. I am starting to think that more often than not, most solutions can be found using a boolean in Anaplan haha. I have a lot of list to list import set up in my models so this issue was helpful to uncover and something to keep in mind going forward.

Truly appreciate your help,

Megha

BrunoRodriguez

Hello @Megha27 ,

Most issues are genunly easy to fix, but you have to have seen them once or spent some time thinking about them. But yes, booleans are the best!

Happy to help!

Megha27

@BrunoRodriguez Yes exactly. Everytime I am done implementing something - in the hindsight it sure looks like the solution was very easy.

unknown

This content has been removed.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385