masterswordz
New member
- Joined
- Apr 28, 2020
- Messages
- 22
- Reaction score
- 0
- Points
- 0
- Location
- Philippines
- Excel Version(s)
- 2016
Hi
May I get some help how to get the output as shown in TABLE3 using Query Editor please?
Unique Key: Column1+Column2+Column4
May I get some help how to get the output as shown in TABLE3 using Query Editor please?
Unique Key: Column1+Column2+Column4
TABLE1 | | | |
Column1 | Column2 | Column3 | Column4 |
data1 | ver1 | ds1 | cp1 |
data1 | ver1 | ds2 | cp1 |
data1 | ver1 | ds3 | cp1 |
data2 | ver1 | ds1 | cp1 |
TABLE2 | | | |
Column1 | Column2 | Column3 | Column4 |
data1 | ver1 | ds1 | cp1 |
data1 | ver1 | ds2 | cp1 |
data2 | ver1 | ds2 | cp1 |
data2 | ver1 | ds3 | cp1 |
data2 | ver1 | ds4 | cp1 |
TABLE3 | | | | |
Column1 | Column2 | Column3 | Column4 | Column 5 |
data1 | ver1 | ds1 | cp1 | no change |
data1 | ver1 | ds2 | cp1 | no change |
data1 | ver1 | ds3 | cp1 | deleted |
data2 | ver1 | ds2 | cp1 | modified |
data2 | ver1 | ds3 | cp1 | add |
data2 | ver1 | ds4 | cp1 | add |