Dynamic Filter
- 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
Company Name - original: This names will change every month. How can I create a dynamic filter based on whatever new branches will come up here. Posted Currency: IT could be different every month. Is it possible to filter out whatever new unknown branches will come and corresponding Currency tabs for future new brunches and currencies?
Appreciate your help.
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you simply need to track if a new value is entering your data set and filter this out, I'd recommend creating an external "values" table you store in a shared folder, where you append new unique values at every run. Here you would track the Company names and the Posted Currencies and whatever other column value you need.
Every time you run the workflow; your process would look to the external mapping file to see if the value is there.
- if the value is there then it is not new
- if the value is not there you would want your workflow to append the value to the values mapping table, so it is not treated as new in the next workflow run.
Hope this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to understand why you would need it to be dynamic?
Would making an In('London Branch','NY Branch'...etc) work?
The only other thing I can think of is if you have a drop down be populated and select which 'new' company names you want filtered out. This would be run as an app.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@n8rushton : The ask for the team is: In that report it is not always same branches of business. Usually they manually pivot the data. I want to create separate tabs for all new branches or entities and everything will be separate tab.
So anyhow, if I could any formula that populate new tabs.
Ans: Would making an In('London Branch','NY Branch'...etc) work? it would work when I know the data set. In the unknown Data It won't work. I want to handle the unknown potential data flows.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes, the tabs can be generated from the output tool based on field name (or done with a formula).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@n8rushton Awesome very good to know. Could you please share an example with my dataset or data from anywhere? That would be great help. I could process easily. Appreciate your help and efforts.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@n8rushton Thank you for helping me in the learning process.