How to split values from one column in to 2 columns?
I have a column that contains values that are 4 digits. I want to divide them up in to 2 separate columns.
The first 2 number are the % of the discount, and the last 2 are the length
Ideally it would be the % and contain 30, 40, 35, 40 ,etc...
Then Length would have the last for digits like 02, 02, 03, 02, 04, etc..
I am not sure how to accomplish this in the ETL
Best Answer

Substring starts at position 1 so you'd need to start as position 3 with a length of 2.
It'd look something like this using a string operation tile:
**Was this post helpful? Click the heart icon**
**Did this solve your problem? Accept it as a solution!**0
Answers

You can utilize a formula tile and use the LEFT AND RIGHT functions to get the left 2 digits or the right 2 digits but note that if it’s not 4 digits you’ll get unexpected results. Alternatively you can utilize the sting operation tile to pull out pieces of a string as well
**Was this post helpful? Click the heart icon**
**Did this solve your problem? Accept it as a solution!**0 
@GrantSmith If I wanted to pull out the first 2 numbers in the column to created a 'Disc%' column would the operation = 'substring' and the the start position 2 and substring length 2 as well?
0
Categories
 10.6K All Categories
 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
 338 Workbench
 250 Domo Best Practices
 11 Domo Certification
 460 Domo Developer
 47 Domo Everywhere
 100 Apps
 703 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 22 お知らせ
 62 Kowaza
 295 仲間に相談
 649 ひらめき共有