Hey ​@Brian Mondello ,

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 ​@CDALMAY , 

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 ? 

Hi, ​@Brian Mondello 

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