Magic ETL / Domo Workbench
Hello,
I'm trying to create a simple enough transformation when uploading a .csv file via Domo Workbench - take a value from a certain location, copy it and create a new column filled with it.
e.g. (in this case Row2, Col1)
Col1 Col2 Col3 Col4
Row1 aaa aaa aaa aaa
Row2 bbb aaa aaa aaa
Row3 aaa aaa aaa aaa
Row4 aaa aaa aaa aaa
should become:
Col1 Col2 Col3 Col4 Col5
Row1 aaa aaa aaa aaa bbb
Row2 bbb aaa aaa aaa bbb
Row3 aaa aaa aaa aaa bbb
Row4 aaa aaa aaa aaa bbb
Is there a way to do it using any ETL tools?
Thanks,
.
Comments
-
Can anyone help with this request?
0 -
user08458,
Great question! This is a multi-step process. Let’s see if we can walk through this together. Please reference the screenshot below as you proceed through these steps:
- Input Dataset: Load your dataset to Magic ETL via the Input DataSet
- Filter Rows: Use the Filter Rows function (Edit Data section) to isolate the record you would like to replicate. In this instance, this is Row 2. The action is labeled as "BBB Filter".
- Select Columns: Use the Select Columns function (Edit Columns section) to select the pertinent fields you want to add to each record. In this instance, this is Col 1
- Add Constant: you will need two constants:
- The first constant is built off of the Select Columns
- This constant (Constant 1) will create a new field on which we can join Constant 1 and Constant 2 from the next step. We created a field called “Join” with a value of “True”.
- This constant is built off of the Original dataset.
- Here, we create a new field (Constant 2) which we can join onto Constant 1 in the next step. In order to join, we have to have the same value. Again, we created a field called “Join” with a value of “True”.
- The first constant is built off of the Select Columns
- From the Edit Data section select the Join Data function to join these two constants together on the new column. In this instance, the new fields called “Join”.
- Use the Select Columns function to select the original fields and the new field that you just added.
- Use the Output DataSet function to create your final dataset.
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 11 App Studio
- 27 Variables
- 578 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 351 Distribute
- 91 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive