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
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
Hi @ShankerV ,
Many thanks for the prompt response.
Would like to ask how do we settle the following type of input data:
Thank you.
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |