The error of Excel Writer

[zero]

I’m a freshman about the function of node. What should I add the node to change the type efficiently.
This is my datas’ information.Then I can export to excel.

ERROR Excel Writer 0:249 Execute failed: Unsupported column type ‘List’. Please remove corresponding column(s) from the input table.
Thank you very much.

[bruno29a]

Hi @zero , The Excel Writer unfortunately does not support columns of type List.

You can do either of the following:

1. Expand the list to columns
2. Convert the list to a concatenated string
3. Remove these columns

I put something together for you for options 1 and 2.

Input data:

Results of option 1:

Results of option 2:

Of course, you can then rename the columns as you wish.

This is how the workflow looks like:

And here’s the workflow: Dealing with List for Excel Writer.knwf (16.6 KB)

[zero]

Thank you very much. I will try it.

[bruno29a]

Hi @zero , I made a slight modification to the option 2. I was looking at your screenshot for sample data, and it looks like though the list columns might be different, the other columns might be the same, so the option 2 as it is would concatenate multiple rows in 1 row.

For example, for the input data:

Notice that for both records/rows, column5 and column6 are the same, but the lists column1 and column7 are different.

For the previous option 2, it would concatenate both rows in the same row as this:

So, I’ve added a modification to correct this, and the new workflow looks like this for Option 2:

And here’s the new version of the workflow:
Dealing with List for Excel Writer.knwf (21.2 KB)

[bruno29a]

Hi @zero , did it work? Don’t forget to use the 2nd version of the workflow if you are going to use the Option 2.

I realized that I only showed the final result of the first version, and forgot to show the final result of the second version, which may lead to believe that it was not working.

Here’s the results of the second version of the workflow for Option 2:

It does not merge the rows, which is how it should be

[zero]

[quote=“bruno29a, post:4, topic:35220”]
new workflow looks like this for Option 2
[/quote]Yes, it is ok. I also add the Column Rename node. It does work too.

Thank you very much!