Group by and bring all the rest columns based on the group by value
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
Mhnd
8 - Asteroid
‎06-10-2023
11:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I have data in three columns:
- [FileName] contains 14 unique name.
- [name]
- [value]
I want separate the dataset based on the unique [filename] and bring all values of [name] and [value] which belongs to that [filename], I could do filter tool and repeat it 14 times but i want something smarter than this.
Thanks
Labels:
- Labels:
- Dynamic Processing
6 REPLIES 6
binuacs
21 - Polaris
‎06-10-2023
11:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Mhnd Do you want the output in separate tabs in an excel file, like unique1, unique2, and unique2 or three different excel file?
binuacs
21 - Polaris
‎06-10-2023
11:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎06-10-2023
11:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks, but I do not extract them to output file, I have to complete the workflow after the separation
binuacs
21 - Polaris
‎06-10-2023
12:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Mhnd How you want the output then?
‎06-10-2023
12:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎06-10-2023
02:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Mhnd Dynamic filter is possible in Alteryx, but what would be your next step after filtering the data? If you provide that part also I can create a batch macro based on your requirement, which will be dynamic
