hello i am trying to use the cell replace node as a “dictionary” basically checking 2 numbers (that are now strings) and it refuses to give me the result of it it always comes as missing any ideas on why this problem might be happening??
Limpesa de Data.knwf (35.3 KB)
the important columns are (on “serviço td cidd”) are “cod.LC” and “Município atribuido…” (on theGalloro_) are “COD_FED”, “COD_MUN” and “ISS_ALQ”
if i compare cod.LC with COD_FED it gets me the ISS
BUT if i use Município atributo, it does not work with FED OR MUN, no matter what i do it does not give me the ISS that would be in that row
Hi @Bleck , unfortunately your data files aren’t inside your workflow so the data hasn’t been included. Could you maybe re-run your workflow and then re-export but don’t tick (i.e. untick) the “Reset workflow before export”, and upload it here again. thanks
Hi @Bleck , thank you for re-uploading. I can now see the data.
In the two Cell Replacer’s that are returning “missing”, (node 24 and node 21 in the picture) you are trying to lookup values contained in “Município atribuido…” where they are found in COD_MUN.
but they have, unless is something on the string? like some how it saved wrong, but here is an example of 2 values that are the same
so unless it has a secret space after one of them or something like that i dont know why the Knime is not counting this 2 as the same (does Knime even count spaces after a word as separated values?)
(also node 21 and 26 where for tests since i was not able to do on the main node 11 since it was suppose to be where all i need is to change the parameters and get the second table i need )
I’ve identified that some of your text does contain additional “space” characters, but these are “non-breaking spaces” I think, and have presumably been introduced in your source data.
If you cannot fix the data at source, a String Manipulation node can remove them with the following expression:
regexReplace($COD_MUN$,"[\\u00A0]","")
I don’t know if all the columns have these characters at the end but I just added some String Manipulations for each column used by the Cell Replacer. You may need to add others, and maybe some aren’t required. I don’t know if there are any other “odd” characters that you’ll need to remove too.