In the sample below, if you begin with the following data set…
Field1 | Field2 | Field3 | Flatten |
A | B | C | One |
Z | Y | X | Two |
D | E | F | Three |
W | V | U | Four |
The data set can be flattened to the example shown below:
Field1 | Field2 | Field3 | Target1 | Target2 |
A | B | C | One | Two |
D | E | F | Three | Four |