Hi everyone, I hope you are doing well,
I am trying to load a text file that has financial figures, but the file has a problem as it comes with scientific notation and of course when loading it with the File Reader Node the column type is forced into string due to the records that have the scientific notation.
See the text file
See the File Reader Node
When I try to convert the columns into numbers using the String to Number node the records or columns are converted into null
I know that is a data problem since it’s origin, but I wonder if there is a way to aproximate such numbers into double.