How to tackle duplication import into numbered list with list formatted properties ?
When importing into the list having properties as list formatted it create new list item with every import even if unique identifier already exists
While importing transactional data into a List (Numbered List) which has properties Country formatted as Country, Year formatted as Year and Amount formatted as Number. In import action, kept unique identifier properties Country and Year but every time import action runs new list item created even after same properties present in the list. What can be the possible solution of it?
Answers
-
Please don't use combination of properties nor load transactional data into a list. Please read this article on how to properly load transactional data.
0 -
In your example, load the transactional data into a module dimensionalized by Country and Time, with a line item named Amount.
0
