Forum Discussion
Need help merging two tables to bring over a column
dufoq3
Community Champion
Community ChampionOK, add this as custom column to Table1
Table.SelectRows(Table2, (x)=> x[ip address] = [ip address])
and then expand System
That gives same result as a Left Outer join. which is not the desired result.
- dufoq3
I don't understand what you need.
Expanded:
it's listed somewhere down line 25-26. do a filter to see firstMac, you will see 192.168.1.6 and 192.168.1.12 listed twice. Same for secondMac
- dufoq3
Check attached pbix file.
I've added System Number to Table2 and sort via this column which is mandantory.
With this it is possible to achive expected result, but maybe you will need to sort also Table1.
Let me know if this is what you want.