Company Lookup on Different Columns

Hello, I am seeing if there is a way to write a beast mode that'll allow a user to input a company name that searches across multiple columns.
For example, I want to look up Wells Fargo as the company name. I have three columns where Wells Fargo can appear under: Buyer, Seller, Lender. Is there a way to allow users to type an input company name and output any result where the company name shows up on any given column?
Thank you!
Best Answers
-
You could append your data in an ETL so it is formatted like this:
Then use Value as a filter.
Another option, use CONCAT() to bring the values of all 3 columns into a single column and then use the "Match Values" filter. The CONCAT() beast mode would be:CONCAT(`Buyer`,', ',`Seller`,', ',`Lender`)
So you'd have a column like this: Wells Fargo, Wells Fargo, Wells Fargo. That when a user filters using Match Values, if even 1 of the 3 columns have that value it would filter to show it.
It would be helpful to see what your card/page looks like to make the best recommendation.If I solved your problem, please select "yes" above
0 -
No. If you want to do it on the card level you need to use the CONCAT() method in a beast mode.
If I solved your problem, please select "yes" above
0
Answers
-
You could append your data in an ETL so it is formatted like this:
Then use Value as a filter.
Another option, use CONCAT() to bring the values of all 3 columns into a single column and then use the "Match Values" filter. The CONCAT() beast mode would be:CONCAT(`Buyer`,', ',`Seller`,', ',`Lender`)
So you'd have a column like this: Wells Fargo, Wells Fargo, Wells Fargo. That when a user filters using Match Values, if even 1 of the 3 columns have that value it would filter to show it.
It would be helpful to see what your card/page looks like to make the best recommendation.If I solved your problem, please select "yes" above
0 -
@ColemenWilson Thank you so much for the recommendations! Is there a way to append the data through ETL on the just the card level and not the entire dataset?
0 -
No. If you want to do it on the card level you need to use the CONCAT() method in a beast mode.
If I solved your problem, please select "yes" above
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 797 Beast Mode
- 78 App Studio
- 44 Variables
- 757 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 72 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive