Having data is my actual data. I am trying to create as per SUBID, if TESTCD = ' DOSE1T' and TPT value is "SBDOSE" then date value should be SB_DATE. Similarly, for DBDOSE.
I am having issues with if I select TESTCD = ' DOSE1T' then TPT value is blank.
Having data:
| SUBID | TESTCD | DATE | TPT |
| 101 | DOSE1T | 19-Feb-22 | |
| 101 | NAUP | | |
| 101 | PHTP | | SBDOSE |
| 101 | DOSE1T | 25-Feb-22 | |
| 101 | NAUP | | |
| 101 | PHTP | | DBDOSE |
| 102 | DOSE1T | 26-Feb-22 | |
| 102 | NAUP | | |
| 102 | PHTP | | SBDOSE |
Expecting output:
| SUBID | TESTCD | DATE | TPT | SB_DATE | DB_DATE |
| 101 | DOSE1T | 19-Feb-22 | | 19-Feb-22 | |
| 101 | NAUP | | | 19-Feb-22 | |
| 101 | PHTP | | SBDOSE | 19-Feb-22 | |
| 101 | DOSE1T | 25-Feb-22 | | | 25-Feb-22 |
| 101 | NAUP | | | | 25-Feb-22 |
| 101 | PHTP | | DBDOSE | | 25-Feb-22 |
| 102 | DOSE1T | 26-Feb-22 | | 26-Feb-22 | |
| 102 | NAUP | | | 26-Feb-22 | |
| 102 | PHTP | | SBDOSE | 26-Feb-22 | |