Need Similar Column names for different connectors
Hello,
I have two different connectors and I am trying to eliminate creating a seperate flow by having a similar column between different connectors.
Eg: Dataflow_details has dataflow_id and dataset_details has dataset_id.
However, none of them have the same column in each. Is there way to join the connectors or do so on card level that I can get the dataset_id in Dataflow_details columns?
Regards,
S.
Comments
-
You might be able to use Dataset Views. On the card level you can't have two datasets but if you are just trying to get them to use the same name for page filtering purposes I usually just make a beast mode called the name of the column from the other dataset and then in the beast mode put the column you want to change.
If you have 2 cards (one for each dataset) you could create a new BM called ID and in each card just put dataflow_id or dataset_id in the BM.
0 -
Hi @swap700
You might try looking into the new Dataset Views to append/union your datasets together. You can also use it to rename columns.
https://domohelp.domo.com/hc/en-us/articles/360046074774-DataSet-Views
The data needs to be of similar types. My question is what are you trying to solve by getting these IDs in the same column? Are you wanting to combine all of the similar information into a single dataset and ignore the rest?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- 7.7K All Categories
- Connect
- 917 Connectors
- 242 Workbench
- 474 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 34 Visualize
- 198 Beast Mode
- 2K Charting
- 8 Variables
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- Workflows
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 23 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部