Join two data set with some duplicate value

[SH_94]

Hi community,

I would like to seek for assistance on the following type of data and the output desired: 

If there are more than one same ID in the data - Input 2 , the output will populate customer detail  by adding * at the behind of each word and also populate the value as zero for those additional line under the amount column

Many thanks

[ShankerV]

Hi @SH_94 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @SH_94 

Step 1: Input dataset 1

Step 2:

Step 3:

Step 4: 

IF [ID]=[Row-1:ID]
THEN 0
ELSE [Amount]
ENDIF

Step 5: 

IF [ID]=[Row+1:ID] or [ID]=[Row-1:ID]
THEN [Customer ]+"*"
ELSE [Customer ]
ENDIF

Many thanks

Shanker V

[Christina_H]

You could use a couple of multirow formula tools to set the values.  I've used a tile tool and single formula tool instead.

[Christina_H]

Actually, you want all customer rows marked if there are duplicates, here's an update that does that.

[SH_94]

Hi @ShankerV ,

Many thanks for the prompt response.

Would like to ask how do we settle the following type of input data:

Thank you.