How to create two or more import actions into the same module

Lets say i have a source file need to be imported into module. Few of the line items need to be cleared before import for all rows and few others need not. How can we create two import actions by keeping the same target module and same source file.

One work around is splitting the module, but am i missing some other way?

Thanks

Arun

Accepted answers

Harsha

Hi @ArunManickam

1. To Clear few line items for all the rows, you can create another line item say "CLEAR" with blank value and create saved view with only clear line items.

2. Import into same module with clear saved view. Map CLEAR line item to the line item which you want to clear before importing. you can ignore remaining which you don't want to clear.

Note: You have to create multiple CLEAR line items to clear the multiple line items.

3. Import new file which you want to import.

Hope this helps.

Harsha

All comments

karank_*4578

Combine the file as one and import

Harsha

Hi @ArunManickam

1. To Clear few line items for all the rows, you can create another line item say "CLEAR" with blank value and create saved view with only clear line items.

2. Import into same module with clear saved view. Map CLEAR line item to the line item which you want to clear before importing. you can ignore remaining which you don't want to clear.

Note: You have to create multiple CLEAR line items to clear the multiple line items.

3. Import new file which you want to import.

Hope this helps.

Harsha

Misbah

@ArunManickam

If I understood your question correctly you are trying to Clear few line items (lets say 2 out of 5) across all dimensions in a module.This is where I am confused "Few of the line items need to be cleared before import for all rows and few others need not" What is few others need not - is it line items or Rows ? Are these applicable to all dimensions?

Anyway let me share what I understood thus far - As you know that having two imports with the same target and source will not happen. So why didn't having a process with clear in the first import and load the source file in the second import come to your mind. I am sure there is something that I am missing here and there is a catch

**You can keep the formatting of Clear line items as No Data so that there can be some space optimization.

Thanks,

Misbah

ArunManickam

Hello,

I want to purge few line items for all the rows and other line items i just want to update the values from the file. I am trying to leverage the "clear option" under the line item tab.

But this option is meant for all line items in the import or none. So I am trying to create two imports between same source and target.

Thanks

Arun

Misbah

@ArunManickam

Here I have created 4 Line items i.e., Line item 1,2 3 & 4. Line items 1 and 2 need to be zeroed out and Line items 3 & 4 needs to be updated. Below snapshot is before loading the File

Step1 - I load the file as usual into the module. Snapshot of file is as below

Data gets loaded into the module as usual. All the cells gets updated as of now

Step 2 - I have created two more line items i.e., Line item 5 & Line item 6 with No Data format.

Step 3 - Created an import which mapped Line item 5 & Line item 6 to Line item 1 and 2 respectively & ignored Line item 1 and Line item 2 in the source

Step 4 - Create the Process of both these imports and put them in the same order and Run it.

Step 5 - See the results in the Target module. Line 1 and Line 2 are zeroed out and Account 3 and Account 4 are updated in Line 3 & 4

Thanks,

Misbah

alexpavel

@ArunManickam I would leave always "Mapped Items in source" in the tab of the items in the import actions.

This is not the tab where you clear all the rows of that line item or not. If you choose "all items" it will be cleared all input line-items in the module..which can be risky because you could have also some line-items that are manually changed.

It is in the other tabs of the other lists you can choose the "rows" to be cleared using the same options, but for the other lists.

But, from what I understood from your request, what you need to achieve is not possible using this flags, also because, indeed, you cannot create in Anaplan 2 different actions based on the same source and the same target.

I would use the solution proposed by @Harsha and create another action in order to clear all rows for the line items that you need to be cleared "ALL" and create this actions maintaining in all tabs for all lists: mapped rows only flagged. ("matched items in source").

Quick Links

Can you help?

Unanswered questions

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…
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…