MULTIPLE ENTRY

[Johmz]

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

[Raj]

@Johmz Please find attached
mark as done if this is what you were looking for.

[Qiu]

@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?

[nagakavyasri]

@Johmz Try this:

[Johmz]

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