How to output files according to column values

[ThomasChen]

Hi guys. I want to output my data into different sheets in excel. The content in different sheets depend on the values in column “zone”.
For example, column zone has values “East, West, North and South”. The data will be output into four sheets named “Zone_East, Zone_West, Zone_North and Zone_South”. Also, in “Zone_East”, it only has value “East” in the column “Zone”.

[HansS]

Hi @ThomasChen

First split your data in 4 subsets (N,E,S,W), and then add every subset as a sheet to your Excel file. You can add the Excel-sheet import port by clicking on the three dots on the bottom left of the EXCEL writer.

gr. Hans