Magic ETL Joins - include table name as prefix
Hi All,
When joining tables in the MAGIC ETL, how do I include the table name as a prefix for the columns?
Sometimes the 'Select Columns' transformation offers a rename suggestion in the format, 'TableName.ColumnName' but it is not always suggested and requires using the 'Select Columns' transformation before each join.
Currently renaming columns but surely there's a better way:
Let me know!
Kind regards,
Best Answers
-
@Domomon Yep I've added this as an idea here, give it a vote if you still want!
https://dojo.domo.com/main/discussion/57659/option-to-add-prefix-in-magic-etl-joins/p1?new=1
0 -
@MarkSnodgrass a solid workaround:
1) Join the table once
2) Join the same table again3) 'Fix' all dupe named columns to the right/left - this auto generates the prefix as we know
4) Remove the first joinThe 2nd join widget keeps all the prefix columns.
Hope this helps for the time being folks!0
Answers
-
On the join tile, under step 3, you can click the + sign to make as many alterations as you want on column names by choose the rename option. It defaults to the name of the tile before it followed by a period and the column name. You can edit it to however you want.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Hi @MarkSnodgrass unfortunately, when the columns have 'no conflictions found' it doesn't include the table name as a prefix by default (see the rename input box empty):
I'm looking for the option to add a prefix for conflicting and not conflicting columns.
0 -
@NateBI even if there are no conflicts, in the Rename To box, you can type whatever you want, so you can type in the tablename.columnname for each column. It is manual, but that is how you would accomplish what you want.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
@MarkSnodgrass Yep I understand, this is essentially what I've achieved with 'Select columns'. When there are 40+ columns per table and multiple tables being joined, having to rename each column makes for a slow day. It may be one for the feature suggestion then!
2 -
@Domomon Yep I've added this as an idea here, give it a vote if you still want!
https://dojo.domo.com/main/discussion/57659/option-to-add-prefix-in-magic-etl-joins/p1?new=1
0 -
@MarkSnodgrass a solid workaround:
1) Join the table once
2) Join the same table again3) 'Fix' all dupe named columns to the right/left - this auto generates the prefix as we know
4) Remove the first joinThe 2nd join widget keeps all the prefix columns.
Hope this helps for the time being folks!0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 727 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