Hi,
I have set of data which is need to identify the number of field and which criteria is need... see sample table data.
Input
LOAN | ID | ID1 | ID2 | ID3 |
1234 | ID001 | ID001 | ID012 | ID023 |
1234 | ID012 | ID004 | ID015 | |
1335 | ID023 | |||
2564 | ID004 | |||
7458 | ID015 |
output should be this - if loan entry is >1 with different ID then show unique LOAN and ID should be show one only per hierarchy (ID1 then ID2, least ID3)
Output
LOAN | ID |
1234 | ID001 |
1335 | ID023 |
2564 | ID004 |
7458 | ID015 |
@Johmz Please find attached
mark as done if this is what you were looking for.
@Johmz
I was not able to fully understand the maning " unique LOAN and ID should be show one only per hierarchy (ID1 then ID2, least ID3)"
Can you kindly elaborate?
I have 2 entry per loan LOAN# with different ID#. We need to show 1 entry only per LOAN# with priority ID#..
example input.
LOAN# | ID# |
1234 | ID3472 |
1234 | ID0221 |
3456 | ID5122 |
3456 | ID2134 |
5678 | ID6571 |
5678 | ID03114 |
ID# PRIORTIY
PRIORITY ID# | 2ND PRIORITY ID# | NON PRIORITY ID# |
ID3472 | ID0221 | ID0021 |
ID6571 | ID1122 | ID5122 |
ID0003 | ID2134 | ID03114 |
ID3021 | ID0014 | ID6578 |
OUTPUT LIKE THIS..
LOAN# | ID# |
1234 | ID3472 |
3456 | ID2134 |
5678 | ID6571 |