How do I import only 1 occurrence without errors?

wld002

I have a DATA module with a line item named "Scenarios." I need to import this line item into a list also named Scenarios list. The data module is dimensionalized by a different list so I cannot use the isfirstoccurence() formula. What's the best practice when it comes to importing this line item into a list as to not have any errors pop up every time, I run the action? Right now, of the 1000s of line items, there's only about 10 unique values I need to import but I can't figure out how to set up a filter or which formula to use.

SriNitya

@wld002 You can use ISFIRSTOCCURRENCE() function.
https://help.anaplan.com/isfirstoccurrence-f3a4e998-fda4-42e5-aa48-05bcf6afd852
The result of ISFIRSTOCCURRENCE is boolean, this boolean line item can be used as filter and create saved view, using the saved view import data into list.

Dikshant

You can use ISFIRSTOCCURENCE function and here is an example

ISFIRSTOCCURRENCE(Scenario Line Item, Name of the list applied in the DATA module)

This will give you the first occurrence of Scenario line item in Source DATA module.