Unsupported column type '?'. Please remove corresponding column(s) from the input table.

Hi

I am getting this error but however i do need these columns as these contains data. Is there any way to convert ? into number/string


Welcome to the forum @hari251.

Have you tried using the Column Auto Type Cast node?

1 Like

Getting below error.

Have you tried using the Transformation tab of the Excel Reader node to enforce the appropriate data type for that column?

1 Like

Do i need to make any change?

Do i need to make any change?

Order number is a long integer. If you want it to be a string, then try setting it to be a string.

Have tried that but still same error.

Hi, @hari251 .

If you attach a sample of your work flow, we can try to help you better.

Regards
Hugo

Hello @hari251 and welcome to the KNIME community

‘SM’ to the win! You can arrange it with ‘String Manipulation’ node (Replace column option):

to String:

string($target_column$)

to Integer:

toInt(string($target_column$))

And String Manipulation (Multi Column) can handle unknown data type conversion, for the whole DF in one single node.

For your use case, you could place it before the loop end.

BR

2 Likes

Thanks to everyone, Because of this thread, I am able to complete my today’s task before time.

2 Likes

Thanks for the help it worked…

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.