MULTIPLE ENTRY

Question

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

LOANIDID1ID2ID31234ID001ID001ID012ID0231234ID012ID004ID015 1335ID023   2564ID004   7458ID015

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

LOANID1234ID0011335ID0232564ID0047458ID015

Johmz · Answer

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#1234ID34721234ID02213456ID51223456ID21345678ID65715678ID03114

ID# PRIORTIY

PRIORITY ID#2ND PRIORITY ID#NON PRIORITY ID#ID3472ID0221ID0021ID6571ID1122ID5122ID0003ID2134ID03114ID3021ID0014ID6578

OUTPUT LIKE THIS..

LOAN#ID#1234ID34723456ID21345678ID6571

nagakavyasri · Answer

@Johmz Try this:

Unique loan.yxmd

Qiu · Answer

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