Modules
Merge Entrysets based on multi-VLOOKUP
- Creator:
- aronglennon
- Submitted:
- Dec 19 2006 at 11:46 am
- Last Updated:
- Dec 19 2006 at 3:13 pm
Download Module
Begin your download of this module (138.1 KB total download).
Description
This module takes two tables of data and merges them based on a common attribute. The common attribute in the first table is used to lookup the entries in the second table and appends all attributes in those entries to the first table's entry. This is like a Left Outer Join query.
For example: Suppose you have the following table-
A B C
1 2 3
2 3 4
3 4 5
and a second table that also has data corresponding to A (but not necessarily with A in order)
A D E
1 7 6
3 6 8
2 4 9
1 7 6
2 4 9
This module will lookup what D and E are for each A in the second table using the A values in the first. The output would be:
A B C D E
1 2 3 7 6
2 3 4 4 9
3 4 5 6 8