The error of Excel Writer in Spectral library identification workflow

Hi,
I have meet an error of Spectral library identification workflow that
Excel Writer 6:9 Execute failed: Unsupported column type ‘List’. Please remove corresponding column(s) from the input table.
Thanks!

Hi @zero -

The Excel Writer currently doesn’t support writing of list columns from KNIME. I see you already have a Split Collection Column included, presumably to deal with such a list, so maybe all you need is a Column Filter to remove your list before writing?

3 Likes

Hi @zero , you can remove the list column via the Column Filter as per @ScottF 's suggestion, or you can have the column removed during the split operation.

You just need to check the box “Replace input column” in the configuration of the Split Collection Column node that you are using:
image

This will take care of removing the list column automatically.

4 Likes