Salesforce amount field importing as text
Hi,
when importing (direct from the server via the connector) data from SFDC, the amount field is coming through as text, now it does have the currency denomination in it (EUR, USD etc.) and commas/periods but even when taking these out via a replace in the ETL it still will not convert the field to a numeric field.
any suggestions on how to overcome this welcome
Thanks in advance
Best Answer
-
Best is to ensure the column is set as a number type of some kind on the dataset side. This can be done through MagicETL/Redshift. If it can't be done, do the Beast Mode trick. And if that doesn't work on the preview, try saving the card first and seeing if the full card view will display the card correctly even though it doesn't appear to on the card builder. And if that doesn't work, get on the phone with support.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
Sometimes in my beast modes I've been able to multiply text, that should be a number, by 1. Then I use that beast mode in my cards.
For example, '3'*1 usually resolves as 3*1 to get 3.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
I am also having this same issue, when I multiply the field by 1 in beast mode it shows as a number field but when I try to use it in a visualization I get the errror "Preview could not be loaded, please try again".
0 -
Best is to ensure the column is set as a number type of some kind on the dataset side. This can be done through MagicETL/Redshift. If it can't be done, do the Beast Mode trick. And if that doesn't work on the preview, try saving the card first and seeing if the full card view will display the card correctly even though it doesn't appear to on the card builder. And if that doesn't work, get on the phone with support.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Thanks all
Managed to convert to text after replacing the text as ""
there are limitations in the error reporting as unless it narrows it down to just one specific problem it doesnt tell you what it is, just that there is a problem, the same with calculations (from my experience so far anyway)
0 -
Hi Everyone -
I have posted an idea for this to be fixed, and also pointed out that this issue does not exist in the downloads to Excel.
Repair how Domo handles the 'Amount' field from Salesforce
I hope this helps!
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive