Azure Data Factory - Mapping column headers to lower case

Chris 146 Reputation points
2022-06-18T00:05:40.817+00:00

I am trying to use the mappings in the 'select' activity for data flows to lowercase the column headers.

The idea being to select all column headers and and map to lowercase.

Here is an example of what I tried.212569-mappings.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments No comments
{count} votes

Answer accepted by question author
  1. Subashri Vasudevan 11,306 Reputation points Volunteer Moderator
    2022-06-18T07:45:07.91+00:00

    Hi @Chris ,

    Thanks for using Microsoft Q&A platform.

    Try this, use select transformation and remove all mappings, and use the below rule based mapping

    212570-screenshot-20220618-131236.jpg

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.