Comments
-
You can easily do this in the Magic ETL dataflow. First get your input dataset: Then use the 'Collapse Columns' action and configure it in the manner shown below: You can then preview the output, which should look like this: You will then need to add an output datasource and you should be good to go. Hope this helps. -----…
