We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Join two data set with some duplicate value

SH_94
11 - Bolide

Hi community,

 

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

SH_94_0-1678881054362.png

 

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

 

 

 

5 REPLIES 5
ShankerV
17 - Castor

Hi @SH_94 

 

One way of doing this.

 

ShankerV_0-1678881693271.png

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @SH_94 

 

Step 1: Input dataset 1

 

ShankerV_0-1678881740033.png

Step 2:

ShankerV_1-1678881765878.png

 

Step 3:

 

ShankerV_2-1678881784841.png

ShankerV_3-1678881799567.png

 

Step 4: 

 

ShankerV_4-1678881817605.png

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

ShankerV_5-1678881828569.png

 

Step 5: 

 

ShankerV_6-1678881870955.png

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

 

ShankerV_7-1678881881703.png

 

Many thanks

Shanker V

Christina_H
14 - Magnetar

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_0-1678881897742.png

 

Christina_H
14 - Magnetar

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

Christina_H_1-1678882205924.png

 

SH_94
11 - Bolide

Hi @ShankerV ,

 

Many thanks for the prompt response.

 

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

SH_94_0-1678909451315.png

 

Thank you.

 

Labels
Top Solution Authors