Joe
200
100
Mary
250
100
input 1
Joe
400
250
100
Jane
400
100
Mary
500
250
50
input 2
Method 1: easier, but static to this example (e.g. new data e.g. columns might break it)
C:\Users\ANDREW~1.UTT\AppData\Local\Temp\Engine_31260_f3aa0530bcf046bbb36c88d6bdc9c1cd_\Engine_18268_e4e758eda4fd47b181ed3106023a4959_.yxdb
Single
Profile
Warning
All
ByName
Method 2: This way is dynamic, so if data changes or new columns added in future, should still work
C:\Users\ANDREW~1.UTT\AppData\Local\Temp\Engine_31260_f3aa0530bcf046bbb36c88d6bdc9c1cd_\Engine_18268_c36df73be9cb4610b92f108d3a3a5afc_.yxdb
Single
Profile
Warn
Warn
Warning
All
ByName
"Name","Name2","Value"
True
True
True
False
False
False
False
False
False
upper
"Name","Name2","Value"
True
True
True
False
False
False
False
False
False
upper
,
Horizontal
joins