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.
Domosapien
**Say “Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- 10.7K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 101 Apps
- 705 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 23 お知らせ
- 63 Kowaza
- 297 仲間に相談
- 649 ひらめき共有