I need to remove the “0” zeros from the output table after performing the Missing Value Node removal of "?’ placed into all tables.
I concatenated many tables and essentially any time there’s a blank cell KNIME places the infamous “?” symbol. Using the “Missing Value” Node to clear “?” from the text cells (string cells) works fine. But the Node forces me to replace blank integer cells with a zero “0”.
I cannot figure out a way to clear these zeros and their associated comma separating them from the numeric identifiers I am using. Please see the events and results graphically attached here.