I have a file which contains my FACT table data (financial data) where the data has alpha characters to show negative numbers.
Example Alphas convert to numbers
0 1 2 3 4 5 6 7 8 9
p q r s t u v w x y
Field that come in as 14445v = -1444.56 (negative number)
Field that come in as 14445 = 144.45 (positive number)
I am wondering how to treat the alpha characters so I can transform the numbers to the negatives - I can replace values to bring in the numbers into the column but not sure about the step to show the negative numbers. Also is there a way to insert the decimal place the only way I thought was to split the column and then merge with the decimal inserted?
Also wondering whether I should further unpivot the data - Columns are as follows (Period is theYear and Month Number so 202001 is July 2020)