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).
所以当我导入Customer-Supplier列表,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?
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?
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.