Identifying New Items inserted in a List

I have a list of 'n' items and I run an import action on the list. The numbers of items in the list is now 'm'. How can I identify the items that were inserted in the current import.

The import file can contain the items that are already present in the list as well.

E.g : Initial List - 1, 2, 3, 4, 5

List after import - 1, 2, 3, 4, 5, 6, 7

Import file - 4, 5, 6, 7.

Is there a way where I can flag or identify only 6 and 7 ?

Accepted answers

HimanshuRaj

I can suggest this:

To create 3 Boolean line items (True, Existing, New) in a module dimensioned by this list

Line Item True - Formula (True)

Line Item Existing - Manual

Line Item New - Formula (NOT Existing)

Run an import into Existing line item from True line item at the start of process: This will identify all the existing line items

→ It will update 1,2,3,4,5 as True in Existing Line Item and 6,7 as True in New line Item

Cheers!!

PulkitChawla

@kevinsanghoi - My bad, I read it incorrectly.

You can achieve this by going with a staging list and module approach. I will be a lengthy process but here is what you can follow:

New a new list (staging List) from your existing list that will have all the members of your existing list.
Load file from excel that will have TRUE property in it. I know this will update the existing members too.(my previous comment approach basically).
Create a staging module using this staging list and make a line item(Clear Member in Main List?) and write the formula as FALSE.
Load the data from Staging Module to main list and clear the Boolean that were marked as true when we loaded the file.

All comments

HimanshuRaj

I can suggest this:

To create 3 Boolean line items (True, Existing, New) in a module dimensioned by this list

Line Item True - Formula (True)

Line Item Existing - Manual

Line Item New - Formula (NOT Existing)

Run an import into Existing line item from True line item at the start of process: This will identify all the existing line items

→ It will update 1,2,3,4,5 as True in Existing Line Item and 6,7 as True in New line Item

Cheers!!

PulkitChawla

@kevinsanghoi - Create one Boolean formatted property into your list named as New Member?

In your upload file, make a column as Newly Added Member and write TRUE for all the items in your file.

Import that file into your list and map the TRUE Boolean in file to the property created in your list(New Member?).

This will also update the property for the members that were already part of the list.

Let me know if you face any difficulty in achieving this.

kevinsanghoi

@PulkitChawla this would not help me identify the new inserts only. This will also flag the updated records as TRUE as you mentioned it as well. I want to identify only the new inserts.

kevinsanghoi

@HimanshuRaj, your solution would work but I provided an example with a fewer list items. The actual list has 1000s of items. The import file also contains 1000s of items with a few new records (70-90). Is there a way to find out these new items without manual intervention ?

PulkitChawla

@kevinsanghoi - My bad, I read it incorrectly.

You can achieve this by going with a staging list and module approach. I will be a lengthy process but here is what you can follow:

New a new list (staging List) from your existing list that will have all the members of your existing list.
Load file from excel that will have TRUE property in it. I know this will update the existing members too.(my previous comment approach basically).
Create a staging module using this staging list and make a line item(Clear Member in Main List?) and write the formula as FALSE.
Load the data from Staging Module to main list and clear the Boolean that were marked as true when we loaded the file.

kevinsanghoi

@PulkitChawla thanks for the response. I believe this approach would work even though it's a length process.

PulkitChawla

@kevinsanghoi - Yeah, I know but will ping you if I get some better solution than this.

CommunityMember111277

a. Create a module using the List

b. Inside module, create 3 Boolean Line Items (LT_1. True, LT_2. Blank, LT_3. if Line Item 1 is not equal to Line 2)

C. Create a Import action from LT_1 to LT_2 (after import - LT_1 & LT_2 should be TRUE, whereas LT_3 should be blank)

d. Load fresh List item from Data Hub or file

e. In the module, after adding new list items LT_3 should be TRUE for only those new items

f. If required, create a fail-safe import action to notify the user about new items. There is no formal notification process, so you have to rely on cloudworks integration failure message to create the same.

g. So, finally before running the import action to load LIST items, ensure you add step C before import action in your PROCESS

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…