Azure的数据工厂复制活动 - 可以列映射为复合材料或使用模板功能？ [英] Azure Data Factory Copy Activity - Can column mappings be composites or use a Templating function?

问题描述

在使用数据复制工厂活动采取从Blob存储分隔文本文件表的存储，我能够指定输入和输出模式以及相关的一对一列映射。

When using a Data Factory Copy Activity to take delimited text files from Blob Storage to Table Storage, I am able to specify the input and output schemas and the relevant one-to-one Column Mappings.

有可能在源模式（也许$$ Text.Format？）串联或格式的一个或多个列以及这些映射到目的地的单个列？

It is possible to concatenate or format one or more columns (with $$Text.Format perhaps?) in the source schema and map these to a single column in the destination?

如果可能的话，这将是特别有用的，如果我还可以设置使用类似的方法分区键（从2个或更多源的列值或更好的是剖开的复合键，SliceStart加级联源列值）。

If possible, this would be especially useful if I can also set the Partition Key using a similar approach (a composite key taken from 2 or more source column values or better still, the SliceStart plus a concatenated source column value).

推荐答案

我从微软对此作出回应，因此想我会分享：

I got a response from Microsoft on this and so thought I'd share:

目前，你不能有ADF复制活动做到这一点。建议的解决方法是让你在正确的格式源文本文件需要启动（即已经连接成一列的任何数据，或者如果你想为片日期使用日期，然后将它添加到该文件作为附加列）。

At the moment you can't do this with an ADF Copy Activity. The suggested workaround is to have whatever data you need in the source text file in the correct format to start with (i.e. already concatenated into one column, or if you want a date to use as the slice date, then add this to the file as an additional column).

然后可以将这些列直接映射到分区或行键作为一对一的映射。

You can then map these columns directly to the Partition or Row Key as a one to one mapping.

这可能需要分隔的文本文件的pre-分析步骤，这是最适合自定义.NET活动在自动进稿器将BLOB文件表存储步骤的上游：

This may require a pre-parse step of the delimited text files, which is best suited to a Custom .NET Activity in ADF upstream of the Blob file to Table storage step:

的https://azure.microsoft.com/en-gb/documentation/articles/data-factory-use-custom-activities/

这篇关于Azure的数据工厂复制活动 - 可以列映射为复合材料或使用模板功能？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！