Hi,

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

So

Field that come in as 14445v = -1444.56 (negative number)

Field that come in as 14445 = 144.45 (positive number)

Etc. etc.

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)

Cheers