Hi Team, I have the input as below and need output as per below mentioned. Can you please how to arrive this. InputAccountDepartmentPO1561223235631234245535364757596868591631027911 OutPutAccountDepartmentPO156/23/631/4/2010223/45/792/5/2011356/536-Mar475759686859

How to arrive unique values as per account

Hi Team,

I have the input as below and need output as per below mentioned. Can you please how to arrive this.

Developer

@Lalaiah
We can use the Summarize Tool

This can be achieved in 3 steps.

1. Sort tool

2. Select tool

3. Multi row formula tool

Many thanks

Shanker V

Step 1: Sort tool

Account -> Ascending

PO -> Ascending

Step 2: Select tool

To modify the data type as V_WString for the columns [Department and PO]

Step 3: Multi-Row Formula

IF [Account] = [Row-1:Account]
THEN tostring([Row-1:Department]) + "/" + tostring([Department])
ELSE [Department]
ENDIF

Many thanks

Shanker V

@Lalaiah
We can use the Summarize Tool

@Qiu & @ShankerV Thank you so much this logic working fine.