Easily transform data using a mapping table between source and destination datasets
join, pivot, rownumber
This template allows source to target mapping t to a target dataset’s schema using a mapping table. The mapping table specifies which columns in the source should be mapped to columns in the target, as well as the final ordering of the columns in the target.
To make use of this template, simply swap out the input_customers.csv dataset with your own input dataset, as well as the columns_mapping.csv with your own mapping table. Note that both the input dataset and the mapping table are expecting the first row of the dataset to be a header row with column names, like most Excel files.