Join on a 2 different keys

iRon7 / Join-Object

Combines two objects lists based on a related property between them.

MIT License

107 stars 13 forks source link

Join on a 2 different keys #4

Closed chaoscreater closed 5 years ago

chaoscreater commented 5 years ago

If I'm trying to join 2 tables pulled from 2 data sources, the keys are named differently. One is named "UserID", the other is named "ID". The data sources are static and can't be modified, but the data in both tables are relevant to each other. How can I join e.g. table1.userID to table2.ID ?

iRon7 commented 5 years ago

You can you two tables with different keys as follows: $Table1 | Join $Table2 -On userID -Equal ID