the Column Auto Type Cast node can not recognize columns with missing value. I’d to suggest, for table consistency, to instate a fallback mechanism which sets a column type i.e. to string in case its values are missing.
Reason is that the String Manipulation (Multi Column) can not cope with unspecified column types. For that I will raise a separate bug report.
there is already a ticket to handle it. (Internal reference: AP-11450). Have added +1 to it. Workaround, depending on your use case, is to use Number To String or String To Number node to convert it.
