I have a 57K row dataset that resembles this UserDomainAssetTypeUser1Domain1laptopUser1Domain1laptopUser2Domain2desktopUser3Domain1virtualUser4Domain3laptopUser1Domain2desktop 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.

If statement help

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.

Data Investigation

Accepted answers

cjaneczko

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.

All comments

Bren_Spill2

@Codedtech - how about something like the attached?

Domains.yxmd

Codedtech

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.

Bren_Spill2

@Codedtech - see attached

Domains.yxmd

ChrisTX

Use a Summarize tool. Group by User and Domain and AssetType, count AssetType. The use a Filter: Count_AssetType >= 2

Chris

cjaneczko

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703