retrieve a row based on a column
- 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'm looking for a solution where we can extract a whole row based on a column.
example we have a column names
when the user enters a name the solution should return the whole info of that person(whole row of that name )
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello @nkrupabd ,
Could you set up an example for me to understand what is really what you are looking for. I don't quite understand it.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
if user gives paycode act we need to output all the rows corresponding to that column value(act)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It sounds like you just need a filter tool, [paycode]='act'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
there are multiple such rows instead of filter tool do we have any other way please
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A filter tool splits the data stream into those that match and those that don't, the T output anchor will have all rows matching the condition. Can you explain why this isn't what you want?
E.g. extending your input data to this:
The output from the filter would be this:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Found the Solution .
Thank you for immediate response.
Really appreciate it.