How to create a unique identifiers with the ETL Transform tool?
How do you create a unique identifier as a new column in any data set?
I'm trying to create a column where I can have a dataset that looks something like this:
Domo1
Domo2
Domo3
Domo4
Domo5
The reason I'm doing this is because I'm trying to join two data sets that have nothing in common, so this would be creating a column in both data sets so that they can join properly.
Comments
-
Hey @Mackenzie,
Sounds like an interesting use-case. Could you explain a little bit more the two datasets and why you're trying to join them together? Typically we have at least a date column we can match on.
Currently, there isn't a way to get a unique identifier for rows in Magic ETL. It's definitely possible in a DataFlow if you're comfortable with writing SQL queries. This would be an excellent suggestion for Magic ETL on the Ideas & Innovations board.
0 -
@Mackenzie, can you answer quinnj's follow-up question to better assist you?
0 -
Hi @Mackenzie actually I think there is a way to create unique identifiers for rows through Magic ETL.
Once you have your input dataset , under edit columns there is an option to Combine Columns.
It allows you to create an extra column (not deleting the original ones) combining all the columns you like, also you can set the character that separates the values (comma, semicolon, tab etc).
example :
Column name = "UniqueID"
Columns to combine separated by '-' = (CustomerName-DOB-Reference#-Year)
hope this helps
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive