Matching values from two different look up tables but not combining them

[alexrod559]

Hey guys,

So I have two look up tables table1 and table 2.

Table 1 
ID Username Fname Lname

Table 2
Username

What i want to do is have my search result look like this

ID, Username(from table one), Fname, Lname, Username(table two)
54, User1, John, Smith, User1 

The reason i want it to do that is because i want to compare the username from table 1 to table 2 so that i can know the user is missing from the source we're getting the table 2 from.

I was able to get append to work but the issue i run into is it wont place the usernames in the same row. It shows all the values for table one fills the columns and then shows all the values for table 2 with the table one columns.

Ex:

ID, Username(from table one), Fname, Lname, Username(table two)
54, User1, John, Smith, (blank)
55, User2, Jane, Smith, (blank)
(blank),(blank),(blank),(blank),User1
(blank),(blank),(blank),(blank),User2

I just want the usernames from table 1 to match and be in the same row as the username in table2

[ITWhisperer]

inputlookup table1
| append [inputlookup table2
  | eval table2="true"]
| stats values(*) as * by Username

[alexrod559]

The unfortunately groups all the values of table one into a single cell.

I forgot to mention that username in table1 has a different field name than username in table 2 but the values match.

[ITWhisperer]

Key piece of info - try renaming so table2 matches table1