This content has been marked as final. Show 2 replies
I have the following columns:
|Customer Name||Level||Product Purchased|
Initially I had the string values for 'Product Purchased' (e.g. 'Eggs,Bacon' for Customer 'ABC') so I used the subfield function during my load, this gave me duplicates in 'Level' and 'Customer Name'.
I want to perform some analysis like the count of levels by Customer Name, but it counts 'A' as 4 as there are four records of 'A' instead of '2'.
what is the best way to do this?