Fill out the blank
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
SH_94
11 - Bolide
‎03-05-2023
12:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi community,
May i know how to fill out the blank for the following scenario? If there is same number appear but for the remark column, it is missing for certain row.
So in order to fill in the missing part, if there is same number appeal , and one of the row have details, then we will copy it and past in the missing row.
Thank you.
Labels:
- Labels:
- Common Use Cases
4 REPLIES 4
binuacs
21 - Polaris
‎03-05-2023
12:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yoshiro_Fujimori
15 - Aurora
‎03-05-2023
12:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yoshiro_Fujimori
15 - Aurora
‎03-05-2023
12:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
atcodedog05
22 - Nova
‎03-05-2023
01:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @SH_94
Here is how you can do it.
1. Data, where Remarks is not empty, can be used as a reference data
2. Vlookup the main data with the reference data to update remarks
Learn more on how to perform vlookup similar to excel in Alteryx: https://community.alteryx.com/t5/Interactive-Lessons/VLookUps-with-Designer/ta-p/80201
Hope this helps : )