How to avoid duplicate item with time (ISFirstOccurence)

CommunityMember125605

Hi I want to make concatinate List.

I have this table.

Customer is determined by Product.

Supplier is determined by Product and Time(week).

Now I want to Customer-Supplier List.

But in this case, I cannot identify unique key(Customer-Supplier Lineitem).

So When I import to Customer-Supplier List, duplicate error has occured.

How can I identify it?

I know I can use IsFirstOccurrence function by making Fake Time List.

But I don't want to do this.

Do you have any idea?

---

I found another method.

I can import Num Lineitem From "Product List Module" to "Customer Supplier Module".

Then I can make "Customer Supplier list" uniquely.

By using this import method, Import cell will drastically increase.

Is there another simple method?

Accepted answers

All comments

M.Kierepka

Hi,
Indeed, you need to use ISFIRSTOCCURENCE() function, but as an argument you need to pass concatenated names/codes of product-supplier (this concatenated ID will also serve as code or name identifier duing import).

CommunityMember125605

Hi, @M.Kierepka.

I know that I have to use product-supplier codes.

But the problem is this module has more than two dimensions.

I think I can't use IsFirstOccurrence Function.

Is there any solution?

M.Kierepka

Hi,
Sorry, I missunderstood the part with time (I thought you are using Fake Time List, but now I see you DON'T want to do this).
So I don't other solution, just the one that you started building, but instead of reimport, you can use [ANY:] function. In your source module put line item that is always just TRUE, and then in your target module, add Boolean line item and put formula like: Source.TRUE[ANY:Source.Customer, ANY:Source.Supplier]

CommunityMember125605

I set the True Lineitem, but I couldn't aggregate it.

I think Supplier has dimensioned by Time and Product.

I don't want to aggregate by Supplier * Customer * Time because of memories.

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…