Substring Function in Magic ETL
There should be a feature to do the typical substring manipulation in Magic ETL. For example, I have had multiple instances where we have a date that is formatted as a string such as '20150101'. There is no easy way in Magic ETL to call out that the first 4 characters are the year, the 2 characters starting at the 5th index in the string are month, and the last two characters are day.
In another example, let's say we have a string of City and State something like 'Seattle, Washington' or 'Salt Lake City, Utah'. There should be function that could return all the substring from the beginning to the first sign of a comma so we could separate the city and a function to grab everything from the beginning of the comma to the end of the string.
Basically, we would just need the functionality of a substring(), substring_index(), and char_index() type of a function.
See this Stack Overflow for example of SQL code you might need for this:
Comments
-
Thank you for submitting this idea @bcooper. I am assigning to our product manager @mattchandler for review.
0 -
Thanks for the feedback @bcooper! We're not actually running SQL on the back-end, but the SQL-like substring functionality would definitley be helpful. I'll get this added to the engineering backlog.
Best,
Matt Chandler
Product Manager, Domo
Best,
Matt Chandler
Domo0 -
Best,
Matt Chandler
Domo0 -
Yes, please.
0 -
Is there any update on this? I want to select the left three of a column in ETL. Thanks
0 -
-
@NewsomSolutions No I did not! Do you have information on how the string should read? Thanks
0 -
Here is what the feature is called in Magic ETL "String Operations", inside that you get the opportunity for substrings and trims.
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有