SOLVED
Attach data to specific ID
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
walkerj7
7 - Meteor
‎01-12-2024
06:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
6 REPLIES 6
flying008
15 - Aurora
‎01-12-2024
06:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎01-12-2024
07:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That works perfectly. Is there a way to replace the null values with zeros?
flying008
15 - Aurora
‎01-12-2024
07:42 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alteryx
‎01-12-2024
07:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@walkerj7 - You can use a Data Cleansing tool or a Formula.
nagakavyasri
12 - Quasar
‎01-12-2024
08:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎01-13-2024
02:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for helping. This workflow worked perfectly!
