Hi,
I'm trying to fill the rows for set of ID's based on the IF condition.
Logic: IF status is "Pass" THEN "check" column value needs to populate in "Output" column for all the rows for each ID.
Input Data:
| ID | Status | Check |
| 1234 | ase | aa |
| 1234 | Pass | Received |
| 1234 | asdfff | b |
| 1234 | asfwe | c |
| 1234 | asfdwre | d |
| 1234 | asdfwer | e |
| 123456 | Pass | Success |
| 123456 | as | q |
| 123456 | asd | w |
| 123456 | asdw | er |
| 123456 | asdf | t |
| 123456 | asdqw | ty |
| 123456 | asda | u |
| 123456 | fasd | i |
| 7891 | asdf | aaa |
| 7891 | Pass | |
| 7891 | q | rrr |
| 7891 | w | rk |
| 8888 | a | rrt |
| 8888 | b | yy |
| 8888 | c | zz |
| 8888 | Pass | Done |
Expected Output:
| ID | Status | Check | Output |
| 1234 | ase | aa | Received |
| 1234 | Pass | Received | Received |
| 1234 | asdfff | b | Received |
| 1234 | asfwe | c | Received |
| 1234 | asfdwre | d | Received |
| 1234 | asdfwer | e | Received |
| 123456 | Pass | Success | Success |
| 123456 | as | q | Success |
| 123456 | asd | w | Success |
| 123456 | asdw | er | Success |
| 123456 | asdf | t | Success |
| 123456 | asdqw | ty | Success |
| 123456 | asda | u | Success |
| 123456 | fasd | i | Success |
| 7891 | asdf | aaa | |
| 7891 | Pass | | |
| 7891 | q | rrr | |
| 7891 | w | rk | |
| 8888 | a | rrt | Done |
| 8888 | b | yy | Done |
| 8888 | c | zz | Done |
| 8888 | Pass | Done | Done |
i have tried below formula in multirow tool to create "Output" field. But it's not working for the all the ID group rows, it's filling the value for row-1 only.
IIF([Status] = "Pass", [Check],
IIF(ISNULL([Row-1:Pass_Check]), NULL(), [Row-1:Pass_Check])
)
Please advice how to achieve this output ?
