CONCAT function not working, any reasons?
I've done what I'm trying to do before, CONCAT(column, ' ', column) as a calculated column in a view. It's not working anymore for some reason. Any reason why? It's only letting me not do it on certain columns
Answers
-
Okay, so it appears that if you're trying to use a column that's used in a join you can't use it in a function if the columns have the same name. Is there any documentation on how to properly reference the table? e.g. tablename.columnname? This is pretty basic functionality
0 -
Once you have your output dataset, that dataset is the table, so there's no way to reference the source table it comes from. If you've done the join in MagicETL, then you should have the option in the join tile to drop duplicate columns. Alternatively, you could just rename the duplicate columns.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
1 -
This is a join on a data view, and I'm only including one of the joining columns in the output (which is why I'm so confused). Doesn't make any sense
0 -
Can you do the concat if you rename one of the columns in the data view?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**
1 -
I tried that too, nothing is working, very aggravating as it seems like basic functionality.
0 -
Hi @Tommy ,
Is this still an issue? If so, can you share a screenshot of what the concat formula looks like and the error?
John Le
You're only one dashboard away.
More video solutions at: https://www.dashboarddudes.com/pantry
John Le
You're only one dashboard away.
Click here for more video solutions:
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive