Thank you for asking this question. To achieve this, you have to do the following (please see the screenshots for details):
- Create Dataset with empty schema or For existing Dataset, clear the schema
- Derived columns based on the fields you required e.g., Code_1: toString(coalesce(toString(byName('Code')), toString(byName('Name')), toString(byName('Extract_Code')))) Number_1: toString(coalesce(toString(byName('Type')), toString(byName('Number'))))
- Map fields in the Sink
Hope this helps. Thanks!
----------
If the above response helps, please "accept as answer" and "up-vote" it. Thanks!