I’ve exported a workflow to a colleague and we notice that the Decimal Separator setting that I had selected for the File Reader Node was not what I had in my own version of the workflow.
I have read through a few posts which talk about the need to check Preserve User Settings for new location. But that appears to be related to changes in the source file. In my case the source file is the same but the user has changed!
Many recommendations are to use CSV Reader Node instead but I’m using File Reader to read in a compressed CSV file and apart from this behaviour it works perfectly.
just tried it out and think it works as expected. So I have created 2 dummy files with exact structure. One is read with File Reader and decimal separator is comma (different from default). Then I have exported workflow and imported it back into KNIME. First file (same location) is read normally (nothing special in this case really) and before selecting second dummy file I have checked Preserve user settings for new location. Second file is then read fine as well (and not fine if setting was not checked!). Does location of your source file changes? If so then you need to check Preserve User Settings for new location before selecting file from new location.
If you will still have troubles with it you can create dummy file, workflow with File Reader which reads this file and send it to me. Will check it then
not sure. Is location shared network drive which both have access to? Are other settings also put to default? What you can try is to control decimal separator with flow variable.