Hi Chris, I have attached it.
The parameters are:
In : Collection_One - Datatable
In : Field_One_Name - String
In : Collection_two - Datatable
In : Field_Two_Name - String
Out : Collection_Out - Datatable
Out : DataTableLen - Decimal
Naturally Datatables are the collections.
The code I've written is basically the form of ""Left join"" , but it wouldn't be difficult to change to an inner join if that's what you needed.
It only works on a single column to column relationship, these being Field_One_Name ( this must exist in Collection_One ), and Field_Two_Name ( this must exist in Collection_Two ). but again it wouldn't take much work to expand this.
You can ignore / remove the DataTableLen item from the code and output, I added it whilst debugging and simply forgot to remove it.
Please let me know if i can help further.
