The Issue at Hand: Excel data mixes text and numbers. Excel columns are defined as “Text”. How can one work around the data in Excel in a way that allows to create a numeric expression?
Below is an example of “text” Excel data (data into the cells).
Annual Salary
$25,000
$100,000
$125,000
There may ways to solve this. Below are two approaches:
FromExcel:
LOAD
[Annual Salary]
,PurgeChar( [Annual Salary],’$,’) AS Salary1
,Mid([Annual Salary],2) AS Salary2
FROM …my Excel;