With 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 ?
Hey
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,
Hi
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 ?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.