Filtering Across 2 datasets with slightly different field names

Hello - I have a group of cards on a page built on 2 datasets. I want to filter them using a selector card that contains the customer's name. On one dataset the field is named "name_full" and the other is "customer_name_full". This is done purposefully and I do not want to make them identical if possible. Can you link those two fields together for filtering purposes without adding more fields to the datasets?
Best Answer
-
You can create a variable that won't clutter up your dataset but you'd have to explicitly list each customer name in the variable and regularly update the variable as customer names are added, deleted, or modified.
0
Answers
-
You don't have to add a new field to the dataset via the etl, but you'll need to add a new beastmode to the dataset at the card level.
On a card where the column is called "customer_name_full", create a beastmode called "name_full" and in the editor section of the beastmode double click the "customer_name_full" column. Click the box to share it on the dataset. This should allow you to use one filter card based on the "name_full" column.
0 -
So no way to do it without sharing beast modes to the dataset? Those really clutter things up.
0 -
You can create a variable that won't clutter up your dataset but you'd have to explicitly list each customer name in the variable and regularly update the variable as customer names are added, deleted, or modified.
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 813 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 773 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 79 Workflows
- 23 Code Engine
- 38 AI and Machine Learning
- 19 AI Chat
- AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 143 Manage
- 139 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive