Creation of a new variable based on delimiter
Hi, In my Data I have a column name 'Origin_Data' which holds data like 'aa/df', 'bb/saw', 'asd/erw' etc. (character type)
Now I want to create a new column say name 'Final_Data' who values will be just the left part of the values of 'Origin_Data' after splitting with '/' - delimiter i.e. 'aa', 'bb', 'asd' etc
Any pointer how to achieve this in Domo will be highly helpful.
Thanks,
Best Answer
-
Yes sorry by ETL dataset I mean the new dataset that you chose to create at the end of the ETL process (Input block-->ETL transforms-->Output block) where the output block is where you created a new dataset. This is what I'm referring to as the ETL dataset.
In the ETL settings just choose the option which will automatically run the ETL everytime your original (input) dataset gets updated. That way you don't have to worry about it. Alternatively you can set it to run on a schedule but having it run whenever the input dataset gets updated is my go to option to make sure things are in sync.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**1
Answers
-
You might be able to utilize the ETL tools for this. Refer to this post regarding using REGEX to create a new column based on that existing column.
https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Magic-ETL-Value-Mapper-Wildcard/td-p/12059
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
If you are comfortable with REGEX, I'm sure you could accomplish this that way. However, you can also use the "Split Column" tile.
0 -
Hi, Where can I get that 'Split Column' option?
0 -
It is a tile in a ETL dataflow. If you aren't an Editor or higher, I don't think you will have access to the ETL dataflow option.
If you are, and you need help creating one, let me know and I can provide some more screenshots.
1 -
Thanks for this.
How can I check if I am an Editor or higher?
Assuming not, can you please provide screenshots creating that -that will be really helpful. Thanks,
0 -
Do you have the ability to click "+", "Data", then "ETL" in the upper right? If so it would mean you're an editor or higher.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
Thanks for this snapshot. Yes I have that access. Appreciate if you please tell me the next step
0 -
Try the following:
- Input dataset is the dataset this is stored in
- Add the "Split Column" ETL block and draw a line from the input dataset to it
- #1: Choose the column that has the values you mentioned that you desire to split
- #2: Choose the delimiter that's being split, for you choose custom and put that slash
- #3: Ignore...I believe
- #4: Create two new columns to store the split values on. So if the column from #1 was "ab/cd" you could create two new columns, one would show "ab" the other "cd"
- Add the Output dataset block and choose a name. This will be the dataset that contains the new columns you're creating.
- If applicable this dataflow to run whenever the original dataset is updated.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**2 -
Thanks for this.
So now I have 2 datasets i.e. Original Dataset + New Data set (this new dataset has 2 columns).
How can I combine these 2 datasets to get a consolidated dataset which holds my original columns as well as 2 new columns with split values?
0 -
The common case is that you wouldn't combine them. In this case since your ETL dataset contains all of the same information + two additional columns you would just use this dataset for all of the cards, the other dataset would exist but only for the purpose of getting the untouched data into Domo, then the ETL would automatically run.
I can see how if you have a data limit this may be of concern to you, maybe someone else or your account manager has a recommendation?
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
Thanks for the clarification. Few more questions.
What do you mean by 'ETL dataset'? Is this the new dataset that I have created? If yes, then I presume based on your answer that this so called 'ETL dataset' will hold all columns from my previous Dataset + 2 additional columns after the split. Please correct me if I am wrong.
How this new dataset will get updated? Let say I add few more raws in my old dataset, then this new dataset will automatically be updated?
0 -
Yes sorry by ETL dataset I mean the new dataset that you chose to create at the end of the ETL process (Input block-->ETL transforms-->Output block) where the output block is where you created a new dataset. This is what I'm referring to as the ETL dataset.
In the ETL settings just choose the option which will automatically run the ETL everytime your original (input) dataset gets updated. That way you don't have to worry about it. Alternatively you can set it to run on a schedule but having it run whenever the input dataset gets updated is my go to option to make sure things are in sync.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**1
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