Azure Data Factory mapping part of a value

1
votes

I'm copying data from an CSV file in Azure Blob storage to Azure Table storage with Azure Data Factory v2. One of the columns in the sources contains UK post codes, e.g. RM1 1AA. I'd like to use the first part as a Partition Key in the table.

I'm trying to use dynamic content, but I can't find a function to target the value. My column is called "pcds". What do I write instead of the "???" to make it capture the first part from the pcds column?

enter image description here

1
azureazure-data-factoryazure-data-factory-2
Hi,any updates now? – Jay Gong

1 Answers

0
votes

Based on my research, you can not set dynamic content for the source column.You could set partition key as source column exactly or just set it from parameters.

enter image description here

However, I provide you with a workaround. You could use Azure Funtion Table Storage Trigger to process the partition key as your want when it is inserted into Table Storage.Just get the partition key value and use str.Substring method in Azure Function code.

Hope it helps you.