I have posted two snippets of data. Not all fields are present in the case of stats, but a few key ones are in each record (mac, ts).
The Mac field in the 1st table has all caps and the second table mac field has lower lower case letters.
Check Attached and let me know if you were looking for the same..
Join of Text Files.qvw 183.8 K
First - avoid the join. It is in most cases unnecessary and can cause both excessive memory usage and record duplication.
Secondly, if the two tables have different fields, they will not be concatenated. They will be associated through the keys (as in your data model viewer). Like a "pending" join.
If you click a "location" and no associated stats are displayed, it just means that you have no stats for this specific location. However, you may have complete disjunct data sets in the key field. If you right-click "location" and "Select All", are then all stats excluded? Or are there stats for some of the mac addresses?