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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 605 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 696 Beast Mode
- 43 App Studio
- 39 Variables
- 659 Automate
- 170 Apps
- 442 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 388 Distribute
- 111 Domo Everywhere
- 271 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 9 Domo University
- 31 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive