If you use more than one FeatureTypes, It will be automatically add 00,01 such serial number.

You can put all of the output connected to a FeatureType, so that it can be
output to the same Sheet.

Hi @goatboy,

Mapping has to be done as shown in the screenshot above. Data will be appended. For example, 1 record from creator and 1 record from Creator_2 are present then output excel will contain 2 rows of data. If you want the values should be in exact cell & column then you have to define using xlsx_row_id (format attribute) for row and User attributes for column.

Hope this helps

feature_type fanout on the writer sets the sheets. Use an attribute for that.

The excel workbook is a dataset. You can fanout a dataset in the navigator panel on the excell writer. parameter>advanced>fanout Dataset This creates separate workbooks.

Thanks Taojunabc, this is close to what i want. Its still a bit messy as each of my "creators" in your diagram above have different destination schema, I end up with a weird (but usable) hybrid schema in my xls file. Thanks for your help, Steve

If you need to output different Schema to the same Sheet, then you can consider
to use the Template, and combining with the method specified xlsx_row_id @pratap
said. Specific Settings refer to xlsxWriterSetting. png.