I want to create a CSV, where the header row consists of names with spaces and brackets.
For example: column one(1),column two(2),column three
The CSV Output node uses the Attribute names with "Write Header" to fill the header row. As Attribute names don't have spaces or brackets, how can it still be achieved?
I haven't tested this, but a possible workaround I see, is to not write the header row with "Write Header", but to create attributes specially for the CSV Output, adding a work item as the first work item with the column names in those Attributes and transfer the attribute values to the new attributes, as the types are not always strings.
Is there a better solution?
Thanks
Bruce