HI experts
I have data which is need validate count of repetation by splitting the group of Ledger ,how many times group of ledger got repeated
001 Ledger ID
| Cash100000 | Active | All FAH Only Ledgers_100000 | Tier_1 |
| OFSS-CB-AMER | Active | All FAH Only Ledgers_100000 | Tier_1 |
002 Ledger ID
| Cash100000 | Active | All FAH Only Ledgers_100000 | Tier_1 |
| OFSS-CB-AMER | Active | All FAH Only Ledgers_100000 | Tier_1 |
i want result.
for first time =1 for second time result =2,3,4....etc
find the attachment
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
Mate I did upload and submit but it wouldnt show off the attachment what is issues in it
Sorry, but I don't understand. There is no attachment and your question is not clear. At least not to me.
find the file there is no best way to reach
https://drive.google.com/file/d/1Tfu6k8ITPL0z31-uUl8ffgNMa9FvOZpU/view?usp=sharing
Thanks for the file and sorry for being slow. now you need to try and explain what you want to do with it.
for e.g
Ledger Has ID NO
A B C D F F
X001 X3223|84848|Active|Onshore Result i want 1
X001 X3221|84838|Active|Onshore Result i want 1
X001 X10384|78376|Active|Onshore Result i want 1
three combination comes under different ledger id
X002 X3223|84848|Active|Onshore Result i want 2
X002 X3221|84838|Active|Onshore Result i want 2
X002 X10384|78376|Active|Onshore Result i want 2
Sorry, but I don't understand. Perhaps someone else can help you.
You're explanation is probably clear for you but try to read it as someone that does not know what you're doing and then see for yourself if you understand it.
There is no logic for as far as I can see to group or log the data uder a number
