阅读文本文件Azure Blob Conteiner [英] Read text file Azure Blob Conteiner

问题描述

大家好，我b
$ b我有疑问。我正在从azure blog conteiner中读取文本文件。

此文件由＃分隔，并具有以下结构：



H>具有文件生成日期的标题

D>系统数据

T>总文件记录



H＃column1＃column2＃column3

D＃column1＃column2＃column3＃column4＃column5＃column6＃column7

T＃column1



我只需要读取文件的第二行，其中包含系统数据。然而，azure博客来源没有跳过第一条记录的选项。执行映射时，组件仅返回三个引用标头
数据的列。



过程是读取blob容器>变换>将数据插入到分段的维度。



是否有任何方法或步骤允许我通过忽略第一行来读取文件数据。

Hello guys,

I have a doubt. I am reading a text file from an azure blog conteiner.
This file is delimited by # and has the following structure:

H> header with the file generation date
D> system data
T> total file records

H # column1 # column2 # column3
D # column1 # column2 # column3 # column4 # column5 # column6 # column7
T # column1

I need to read only the second line of the file, which contains the system data. However the azure blog source there is no option to skip the first record. When performing the mapping, the component only returns three columns that are referring to the header data.

The process is to read the blob container> Transform> insert the data into a dimension of a staging.

Is there any way or step that allows me to read the file data by ignoring the first line.

推荐答案

Hi Luiz，

Hi Luiz,

如果标题行的数量不会改变，只需将平面文件连接设置为跳过＃他们

If the number of header rows is not going to change ever, just set the Flat File connection to skip # of them

这篇关于阅读文本文件Azure Blob Conteiner的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！