Mapping Line Items to List Items with huge data

Options
KartikJain
KartikJain Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 5 New Contributor
in Extensibility

I am unable to import data from my source module to target module because data in source module is under list item whereas in the target module it is under hierarchical line items. The source module has 79 lakh cells under each line item which needs to be mapped into 600 source module list items, it needs to find the correct combination of 3 list items. When I tried for only 10 data cells, one of which matched the 3 layers of hierarchical list items, Anaplan was able to automatically match the list items to the corresponding line items but it took time to process. In case of the huge 79 lakh it takes half an hour to import at the end of which it shows it wasn't able to find any of the line items in the target. 

Tagged:

Comments

  • KartikJain
    KartikJain Member, ALL USERS, Partner, Community Member, Certified Model Builder Posts: 5 New Contributor

    I can't use SUM and LOOKUP as I am importing the data from a different Anaplan model (Data Hub). 

Categories