Hi all,
So I want to join data source 1 and 2 on the first column, but I don't want the 2nd field in data source 1 to repeat (see Output grid). Is there any easy way to accomplish this?
| Data Source 2 |
| W | A | 5 |
| X | B | 5 |
| X | C | 5 |
| X | D | 5 |
| Output |
| W | 5 | A | 5 |
| X | 3 | B | 5 |
| X | | C | 5 |
| X | | D | 5 |
| Y | 10 | | |
| Z | 7 | | |
Thanks!
