As the title implies, I have a workspace where two different workflows have to write to the same CSV but different sheets. How do I go about doing that? I've attempted to use fme_feature_type as CSV File Name but that resulted into 2 separate CSV files as depicted by the image attached
Best answer by f.kemminje
copy the writer feature types. make it two.
and change the shaeetname. concatenate _1 or _2 (to the sheet name attribute )for the second sheet
CSV does not support multiple sheets/tabs. Could you use XLS?
Thanks for the information about CVS. I just tried an XLS writer but this time, the two streams simply combined instead of creating different sheets.
+11copy the writer feature types. make it two.
and change the shaeetname. concatenate _1 or _2 (to the sheet name attribute )for the second sheet
@Mario Federis or use dynamic workflows as described here
@markatsafe Are you referring to this subset of the article (https://community.safe.com/s/article/dynamic-workflows-destination-schema-derived-from). I think I understand the general concept of having the destination read schemas from multiple sources. But could you give an example of how writing multiple sheets into the same excel can be done?
copy the writer feature types. make it two.
and change the shaeetname. concatenate _1 or _2 (to the sheet name attribute )for the second sheet
Makes sense. But definitely not intuitive.
+11Makes sense. But definitely not intuitive.
here is the sample workbench.
