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…