Import Issue

Hi Guys,

I have an issue that I put in a document since for some reason I cannot paste a picture here on the body of this screen. I am sorry if I cannot provide the actual screenshot since it is the clients data. But I recreated it as much as I can.

Please see the attachment for details. And again I appreciate the help

Regards

Import_Issues_RBG_59566.docx

Accepted answers

All comments

jasonblinn

Could you do this via a mapping module and a lookup in your target module as opposed to an import? It seems that you are trying to match one to many on an import which is going to be tough to do. It also means that the import needs to run each time for the data to be correct. If you were to do this via mapping and Lookup then, in theory, the data would be as up to date as your Source module.

Quick Links

Can you help?

Unanswered questions

Anaplan Matillion Integration
I have a requirement to extract last 90 days data from an Anaplan model through Matillion. I wanted to know is there any API which I can use to achieve the same? I have taken a look at the (Integration APIs) Bulk API as well as Transactional API and none of them has a relevant query parameter which I can use to apply the…
How to create Anaplan formula MTD with Input Date
Hi, I'm trying to create a month to date line that is based on a specific input date, not the actual date. Is this possible?
How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…