Hi wonderful community! I have a very weird situation I was hoping to get your help with. I would like to see if anyone has seen this before and maybe has an idea on how to fix it.
I run a very simple combining workflow. The workflow pulls in several files and combines them. All files have the same columns and information, just for different entities. And all files use the same formatting.
I use this combined output to run some analytic workflows which were throwing me some variances. Upon looking into it, it appears that for some reason, during the combining, three columns are truncating and eliminating any decimals and numbers after. There are 16 columns which are all "Double" types and only the MJE column's doing this. Has anyone seen this at all?
I have attached some screenshots of the workflow, the configuration of the only select tool which shows the types, the results for the input going into the select tool and then the results for the output from the select tool. I do not understand what is wrong. Anyone have any input?
***The three columns that are doing this are showing yellow in the workflow. When starting to use this workflow a year or so ago, I had updated those columns to double and the yellow has never gone away.
Thanks so much!
