@shazbot79 I know you've got your solution, but in terms of the principles behind stats vs join. Consider these two data sets Set 1 UserName,Field2
user1@abc.co.uk,aaaa
user2@abc.co.uk,bbbb
user2@abc.co.uk,cccc and then this data set 2 UserName,Fieldx
user1@abc.co.uk,xxxx
user2@abc.co.uk,yyyy
user2@abc.co.uk,zzzz so, when you have a common field, you can either do the following join DataSet1
| join UserName [
DataSet2
| Fields UserName Field3
]
| stats values(*) as * by UserName or using stats DataSet1 OR DataSet2
| stats values(*) as * by UserName Will achieve the same thing, but without the cost/limitations of using a subsearch.
... View more