hello
Can you help me to remove some rows in my load script with the following rule:
after different step i have a table like that:
| Corisq | codntt | nom | nom2 |
| A | 1 | AAA | AAAA |
| B | 2 | BBB | BBB |
| Z | 1 |
| AAA |
| A | 1 | AAA |
|
| Z | 3 |
| CCC |
| C | 4 | DDD |
|
| Z | 4 |
| D |
I would like a script to remove the row
3rd row: Z 1 - AAA => because codntt = 1 exist with a codrisq other than Z
and
Z 4 - D => because codntt = 4 exist with a corisq other than Z
So at the end , i like to have a reduce table like that:
| Corisq | codntt | nom | nom2 |
| A | 1 | AAA | AAAA |
| B | 2 | BBB | BBB |
| A | 1 | AAA | |
| Z | 3 | | CCC |
| C | 4 | DDD | |
Notice:
As you can see , i keep Z 3 - CCC, because does not exist with another corisq other than Z
As you can see , Z 1 - AAA need to be remove, but the 2 rows with corisq = A and codntt = 1 should be kept.
thk you for your help.
Regards
