How to get the count of each unique record in separate column

[dramya]

I have an existing job where i'm getting the data from  tsalesforce component with multiple records where it has similar no. with different details and storing the data in internal DB

I'm getting the data in below sample format.

1. 101 OS

2. 102 Hardware

3. 102 Software

4. 103 Device

5. 104 OS

6. 104 Software

7. 104 Device

My Output has to come as below:

1. 101 OS  -> Single

2. 102 Hardware  -> Multiple

3. 102 Software 

4. 103 Device --> Single

5. 104 OS --> Multiple

6. 104 Software 

7. 104 Device 

Single/Multiple Category has to come in Separate columns. 'Multiple' should come only once for same purchase no. (eg: 104)  only in 1 record as given below:

5. 104 OS --> Multiple

6. 104 Software 

7. 104 Device 

Let me know how we can achieve the above one?

Thanks 

[manodwhb]

@rchinta , use tuniquerow component and get the unique and duplicate records differentflow and take the duplicate flow and generate new column with values like multipule and load into thashoutputs ,from there you read using thashinputs and use tunite and then use tmap and sort the data on id column and by using variable prot derive single value for that new field.

[dramya]

@Manohar B​  - Unsure how to perform this steps.