Attach data to specific ID

[walkerj7]

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.

[flying008 · Accepted solution]

Hi, @walkerj7 

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

[walkerj7]

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

[flying008]

Hi, @walkerj7 

Use formula for [Bouns] :

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

[ArtApa]

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

[nagakavyasri]

@walkerj7 

[walkerj7]

Thanks for helping.  This workflow worked perfectly!