+1With the new functionnality to create dimension based on an other dimension/transaction list, I want to create a concatenation of 2 columns in my transaction list but.. Pigment say there is an error because a lot of rows don’t have unique ID.
Is it existing a “ISFIRSTOCCURENCE” formula or simithing similar to filter my view and solve the point ?
+14Hey
Do you have more than one unique property in your Subsisdiary_Account dimension ?
Could you provide a quick screenshot of your TL (Transaction List) and DL (Dimension List)? It might be easier to help.
Best,
+1Hi
Yes I have more than one unique property in the “Subsisdiary_Account “ dimension that I want to create from my transaction list. This is why I would like to filter only the first occurence of this couple “Subsisdiary_Account” when I want to import list to list.
Here the details :
In my transaction list, I have two columns “Subsidiary” and “Number” (= “Account”) and I concatenate them in a specific column in text format that I call “Subsisdiary_Account” :
I would like to used this text column to create a dimension (call “Subsisdiary_Account”) based on the new feature “import list to list” :
And when I launch the import, Pigment said that the property is not unique → that it’s true!
This is why I would like to know if there is a possibility to filter only the first occurence of “Subsidiary_Account” that I have in my transaction list ?
+4Hi,
I think the way to solve it is to create a property in your Source list where you will set up a formula using RANK() function - it could be considered as an analogue of the ISFIRSTOCCURENCE() - to mark the first occurence when the rank is 1.
The formula could be
Then while configuring the import simply use the Filter data functionality based on that new property.
Hope, it helps
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
