I have a 57K row dataset that resembles this
User | Domain | AssetType |
User1 | Domain1 | laptop |
User1 | Domain1 | laptop |
User2 | Domain2 | desktop |
User3 | Domain1 | virtual |
User4 | Domain3 | laptop |
User1 | Domain2 | desktop |
I'm tying to find a way to create a column that will tell me if a user has an asset on the same domain and if those assets are the same.
Like this if User1 and Domain1 and Asset Type are the same the new field would be True.
Solved! Go to Solution.
@Codedtech - how about something like the attached?
That's a cool solution, but it's not what I need. This gives me an entry for each line, like User1 has 1Asset on domain1. I actually need the output to be True or False if user domain and asset type are the same.
@Codedtech - see attached
Use a Summarize tool. Group by User and Domain and AssetType, count AssetType. The use a Filter: Count_AssetType >= 2
Chris
Here is one way to do it. Create an index field of 1 then use a summarize tool to sum all the "Grouped" fields. Use another formula tool where any of the Sums are greater than 1 is 'True' and anything = 1 is False. Join it back to the original data set.