英文:
Skip rows copy activity
问题
我有问题是关于在adf复制活动中跳过数据源（excel）中的行。
我的数据集如下图所示。我试图跳过第一行并将第二行作为标题。
除此之外，我还添加了一个额外的列，它应该从I2单元格开始而不是从I1单元格开始。
但不幸的是，我无法实现我想要的效果。
任何帮助都将不胜感激。
英文:
I have the issue with skiping the rows from the data source (excel) in adf copy activity.
My dataset looks like on below image. Im trying to skip the first row and make second row as header.
In addition to this I also add the additional column, which should start from I2 cell and not from I1 cell.
but unfortunetly I cant achieve what I want.
Any help is appreciated
答案1
得分: 0
我已经在我的端上尝试了相同的方法，使用Excel作为数据源，Excel表格包含多个工作表。
我想要排除上面的项目ID，即A1
并且我想要将第一行作为标题从A4开始。
因此，我的ADF源数据集配置如下。
而我将数据写入ADLS Gen 2，格式为.CSV。
输出：
英文:
I have tried the same way at my end using the Excel as the Source. and Excel sheet having the Multiple sheets.
I want to exclude the above Item ID which is A1
And I want to start the first row as header From A4.
So my ADF Source data set configuration is like below.
And I am writing the Sink to ADLS Gen 2 As a .CSV format.
Output:
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论