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.
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.
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.
If you are comfortable with REGEX, I'm sure you could accomplish this that way. However, you can also use the "Split Column" tile.
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.
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,
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.
Try the following:
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?