English 中文(简体)
以野心为基础的原始原始档案,应转至Sink ́s公司使用K.K.K.公司数据。
原标题:Copy filenames at source based on wildcard to be transferred to seperate folders in Sink using Azure Data Factory

I m 想把ADF的工作混为一谈,利用制版功能从来源集装箱中转移.子文档,并将这些档案转至ALS Sink集装箱在各自的夹中。

例如:

Source Container A Directory -fileA-20240201.txt -fileB-20240302.txt -fileB-20230201.txt -fileC-20230201.txt

Sink Container B Directory -Folder_A -Folder_B -Folder_C

移交档案 A* 利用野卡将这些档案转给Folder_A. 转移档案B* ,使用野卡将这些档案转交Folder_B. 转让档案C* ,使用野卡将这些档案转给Folder_A. 转让档案 C. 出席情况

Looking for help on config details setting up this ADF job.

Tried to use ForEach nested with a Switch Activity using Case Activity for each file name followed by copy activity.

问题回答

如果你知道目标夹和目标夹的名单,那么你就可以尝试以下办法。

www.un.org/Depts/DGACM/index_spanish.htm 这些是我的抽样投入文件:。

sourcecon
    folder
        fileA-20240201.txt
        fileA-20240311.txt
        fileB-20230201.txt
        fileB-20240302.txt
        fileC-20230201.txt
        fileC-20240310.txt

First create an array variable with letters ["A","B","C",..<till required folders>]. Give this array to a For-Each activity.

建立源数据集和目标数据集。 在目标数据集中,设定了直线参数 倍数——名称,并给出如下数据集的倍数路径。

“enter像以下描述”/。</p

在路旁边,进行复印活动,并提供生成的来源和汇数据集。 在来文方中,使用野生卡路标如下:file@{item()}*

“enterography

在计票中,将数据集参数的“代码”改为“参照标准”。

“entergraph

管道和所有所需档案都将抄送下文等各文件夹。

http://www.ohchr.org。

“enter

www.un.org/Depts/DGACM/index_spanish.htm 在目标夹中创建的文件:

enter image description here

www.un.org/Depts/DGACM/index_spanish.htm 我的管道JSON:

{
    "name": "pipeline1",
    "properties": {
        "activities": [
            {
                "name": "ForEach1",
                "type": "ForEach",
                "dependsOn": [],
                "userProperties": [],
                "typeProperties": {
                    "items": {
                        "value": "@createArray( A , B , C )",
                        "type": "Expression"
                    },
                    "isSequential": true,
                    "activities": [
                        {
                            "name": "Copy data1",
                            "type": "Copy",
                            "dependsOn": [],
                            "policy": {
                                "timeout": "0.12:00:00",
                                "retry": 0,
                                "retryIntervalInSeconds": 30,
                                "secureOutput": false,
                                "secureInput": false
                            },
                            "userProperties": [],
                            "typeProperties": {
                                "source": {
                                    "type": "DelimitedTextSource",
                                    "storeSettings": {
                                        "type": "AzureBlobFSReadSettings",
                                        "recursive": true,
                                        "wildcardFolderPath": "folder",
                                        "wildcardFileName": {
                                            "value": "file@{item()}*",
                                            "type": "Expression"
                                        },
                                        "enablePartitionDiscovery": false
                                    },
                                    "formatSettings": {
                                        "type": "DelimitedTextReadSettings"
                                    }
                                },
                                "sink": {
                                    "type": "DelimitedTextSink",
                                    "storeSettings": {
                                        "type": "AzureBlobFSWriteSettings"
                                    },
                                    "formatSettings": {
                                        "type": "DelimitedTextWriteSettings",
                                        "quoteAllText": true,
                                        "fileExtension": ".txt"
                                    }
                                },
                                "enableStaging": false,
                                "translator": {
                                    "type": "TabularTranslator",
                                    "typeConversion": true,
                                    "typeConversionSettings": {
                                        "allowDataTruncation": true,
                                        "treatBooleanAsNumber": false
                                    }
                                }
                            },
                            "inputs": [
                                {
                                    "referenceName": "sourcefiles",
                                    "type": "DatasetReference"
                                }
                            ],
                            "outputs": [
                                {
                                    "referenceName": "targetfiles",
                                    "type": "DatasetReference",
                                    "parameters": {
                                        "folder_name": {
                                            "value": "Folder_@{item()}",
                                            "type": "Expression"
                                        }
                                    }
                                }
                            ]
                        }
                    ]
                }
            }
        ],
        "annotations": [],
        "lastPublishTime": "2024-03-11T13:35:47Z"
    },
    "type": "Microsoft.DataFactory/factories/pipelines"
}




相关问题
Windows Azure WorkerRole response

I am working on an Azure demo to run Powershell in a worker role. In my web role I add the name of the Powershell script which is to be run to a CloudQueue object. I can print the script output to ...

Windows Azure WebRole stuck in a deployment loop

I ve been struggling with this one for a couple of days now. My current Windows Azure WebRole is stuck in a loop where the status keeps changing between Initializing, Busy, Stopping and Stopped. It ...

Getting a token for Windows Azure

We are looking at Windows Azure, but getting a token appears to be hard now, at least that s what I m seeing in web searches. Anyone tried it or know how to accelerate that process? Any idea how long ...

Developing Azure .Net 4.0 Applications

Presently .Net 4.0 is not supported on Azure. This thread indicates that you will not be able to use .Net 4.0 with VS 2010 until it is supported in the cloud. http://social.msdn.microsoft.com I d ...

.NET 4.0 on Windows Azure?

My google-fu is failing me on this one. As a possible solution to Unit Testing .NET 3.5 projects using MStest in VS2010 (but I ve put this in a seperate question because it s kind of unrelated): Is ...

热门标签