Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
Please help me on below scenario.
we have raw data like below:
ID | NAME | D | STATUS |
1216 | GIREESH | D1 | PASS |
1216 | GIREESH | D2 | |
1216 | GIREESH | D3 | |
1216 | GIREESH | D4 | |
1217 | NARESH | FAIL | |
1217 | NARESH | D5 | |
1217 | NARESH | D6 | |
1217 | NARESH | D7 |
Result: Need STATUS as New Status column if ID and NAME is same.
ID | NAME | D | STATUS | New Status |
1216 | GIREESH | D1 | PASS | PASS |
1216 | GIREESH | D2 | PASS | |
1216 | GIREESH | D3 | PASS | |
1216 | GIREESH | D4 | PASS | |
1217 | NARESH | FAIL | FAIL | |
1217 | NARESH | D5 | FAIL | |
1217 | NARESH | D6 | FAIL | |
1217 | NARESH | D7 | FAIL |
Don't create Dump
If(ID&NAME=Previous(ID&NAME), peek('New_Status'), STATUS) as New_Status
Don't create Dump
If(ID&NAME=Previous(ID&NAME), peek('New_Status'), STATUS) as New_Status