Alteryx Designer Desktop Discussions

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

Attach data to specific ID

walkerj7
7 - Meteor

I have an existing dataset with thousands of rows, and I have another dataset with a few hundred rows that has data that needs to be attached to specific rows.

 

 

ID      Sales.              ID.     Bonus

100.    500               100.     50

101     200               103.     50

102.    110

103.    150

 

Final dataset

 

ID.   Sales. ID

100.  500.  50

101.  200.   0

102.  110.   0

103.  150.  50

 

note: I’ve tried doing a left outer join but I get duplicates with data not aligned to the right column.

 

6 REPLIES 6
flying008
15 - Aurora

Hi, @walkerj7 

 

FYI. and you must care the space or dot in your string.

 

录制_2024_01_13_10_54_40_676.gif

 

录制_2024_01_13_10_58_55_47.gif

walkerj7
7 - Meteor

That works perfectly.  Is there a way to replace the null values with zeros?

flying008
15 - Aurora

Hi, @walkerj7 

 

Use formula for [Bouns] :

 

IIF(IsEmpty([Bouns]), 0, [Bouns])
ArtApa
Alteryx
Alteryx

@walkerj7 - You can use a Data Cleansing tool or a Formula.

nagakavyasri
12 - Quasar
walkerj7
7 - Meteor

Thanks for helping.  This workflow worked perfectly!

Labels
Top Solution Authors