Dynamic Filter based on data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I want to filter out each Product types and make those as separate tab, Product types would be dynamic unable to determine the number of types sometimes it would be 5 types sometimes it would be 15. So how could I filter those types and save it as a sperate tab in output.
I have attached my Input data and expected output result for your reference. Please have a look at it and advise me.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Dhilip_Kumar - you can use functionality of the Output tool to do this - see attached.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Dhilip_Kumar You can use Output tool Capability to achieve this,
you can take sheet names from a column.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much @Bren_Spill @Raj. It is working perfectly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No problem @Dhilip_Kumar. Can you mark both of our responses as solutions? Thanks!
