This isn't going to be the most descriptive problem because I'm just looking for general ideas as to what went wrong with a workflow.
High level summary of my question: What are the reasons why Alteryx would change some numeric values to 0s? I just need general reasons to know where to start. I have an issue where for 60% of records, numbers were changed to 0s.
A little more detail: I have files in a directory that have several tabs. Each tabs contains relevant data, so a macro reads in all the files and joins them into one schema. The schemas between the tabs may be the same or they may change a bit, but in the case that the schema is different, the new fields get appended to the right of the data. This workflow contains several select tools and various functions to alter the data, but to my knowledge, nothing that would change numbers to 0. If this was the case, all numbers in the field would have been converted to 0, but only some were. Please let me know if you've experienced this issue and what you would check to figure out the cause. Thanks!
