I need to be able to change the Salesforce value field ex. USD $10000 to a decimal in ETL...
Best Answer
-
If I understand you correctly, you're needing to strip the non-numeric data from the field and the convert to a decimal.
You can easily do this via the following ETL steps:
First you'll want to add a 'Replace Text' option enter the following the Search term field:
[^0-9.]
And set the 'Use RegEx' check box for the Search as shown:
Once you've replaced all the text with the Empty String option, you then want to 'Set Column Type' and just choose Decimal if that's what you want.
Your resultant dataset at the end should then be workable with a numeric value.
Let me know if you have any other questions,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Answers
-
If I understand you correctly, you're needing to strip the non-numeric data from the field and the convert to a decimal.
You can easily do this via the following ETL steps:
First you'll want to add a 'Replace Text' option enter the following the Search term field:
[^0-9.]
And set the 'Use RegEx' check box for the Search as shown:
Once you've replaced all the text with the Empty String option, you then want to 'Set Column Type' and just choose Decimal if that's what you want.
Your resultant dataset at the end should then be workable with a numeric value.
Let me know if you have any other questions,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
Worked perfectly thanks so much!!
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive