So assume you have the below dataset:
Column 1 Column 2 Column 3
7000 * 30
7000 074* 20
7000 074* 10
1000 075* 9
I have a separate dataset that basically allows me to see all of the possible numbers that can be in column 2. Or in other words it shows all the possible combinations of columns 1, 2 and 3 (the unique identifier I am looking for is ultimately a concatenation of the three columns. So assume the second dataset looks something like this:
Column 1 Column 2 Column 3
7000 0700 10
7000 0710 20
7000 0720 30
7000 0730 30
7000 0741 20
7000 0741 24
7000 0742 10
7000 0742 15
1000 0751 9
1000 0752 9
1000 0753 9
1000 0751 7
1000 0751 4
1000 0751 1
Then I want the final result to be:
Column 1 Column 2 Column 3
7000 0720 30
7000 0730 30
7000 0741 20
7000 0742 10
1000 0751 9
1000 0752 9
1000 0753 9
I assume it would be easy to join the data on a unique identifier that combines the three columns into one field, and add rows to the original dataset based on what matches in the second dataset. For some reason I can't get it to work with what I've tried but I feel this should be a simple fix. Any help is appreciated!
