Output Tool

[SB09]

I am trying to split the data based on one column values into separate excel sheets.
The error I get is No Sheet selected.
When I change the configuration and provide File location and uncheck the option Take File/Table from Field, the workflow runs but the aim is not reached.

[RolandSchubert · Accepted solution]

Hi @SB09 ,

I think, the error is caused by the last (empty) row in your Text Input tool. Delete row 6 in the Text Input tool and it should work fine.

Let me know if it works for you.

Best,

Roland

[SB09]

Thank you, Roland Schubert.

How do I separate one table into two tables based on one column?

In my example, I want to split into 2 tables where one table should include Address=Mumbai and another table should include rest addresses. I need to do this using only the Output Data Tool.