Hi guys,
I'm having an issue with some data that is run through a workflow;
| Apple 1 | Apple 2 | |
| 2300.45677 | 2300.45677 | FALSE |
Apple 1 results are run through a workflow. When comparing with Apple 2 results (manually inputted) using a sanity check "Apple 1 = Apple 2", it comes back as FALSE.
There are no trailing white spaces and display is showing all decimal places. I have read online it might be due to trailing floating decimal points eg. 0.000000001. How do I get rid of this, so Apple 1 = Apple 2?
Pls note the file type is .csv
