Import to list with default value

Hi,

I have an excel file that needs to be imported into Anaplan and update a list. However, I want all the new list-items to be part of a subset, which I want to set at the same time as I import the list. I do not however have any column in my import file to use for setting the subset (that is, a column that says TRUE to import to the boolean)

Is there any way to set a value to "TRUE" as default in a specific import?

Thanks!

/Fredrick

Accepted answers

rob_marshall

@fredrickstraube ,

The only way to do that from the source system (file) is to create a new column within the file with a value of TRUE. If you can't do that, create a SYS "List Name" Properties module where you have the logic built in as line items, create an Action which updates the members to the appropriate subset, create a process with the following actions (import into list from source file, update the list with the appropriate subset members).

Hope this helps,

Rob

fredrickstraube

Hi,
Thanks a lot. In this case, I do not have the opportunity to modify the import file. I did however do a workaround which seems to work just fine.
I created a new “import list” which is numbered. There, I added properties for all my columns from the import file. I then created an “import module” with my “import list” as dimension. There, I created a Boolean with the formula “TRUE”. I then import into my original list from my “import module”, mapping the subset to the newly created Boolean. This also gives me the opportunity to modify the data further before it is imported to my list.
Might not be the easiest solution, but works great in this case!
Thanks a lot for the input!
/Fredrick

All comments

rob_marshall

@fredrickstraube ,

Hope this helps,

Rob

fredrickstraube

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…