Read two columns alone from an excel in Azure Data Factory

0
votes

I have my data in excel file and I am able to read the whole sheet. But I want to read only first column and third column. I have headers in the excel. So I need to read values from A2 and from C2.

I tried reading https://docs.microsoft.com/en-us/azure/data-factory/format-excel . But unable to find a way. Any ways to read these two columns alone. Can any help me what values I have to specify in range. Many thanks!

enter image description here

2
excelazureazure-data-factoryazure-data-factory-2

2 Answers

0
votes

Source file with 4 column

1

Select the column that you want from and Click om Insert Pivot table and grab the range

2

Then open the Source dataset and paste that range and preview the data.

3

Configure the sink and publish your pipeline. Hope, You got your answer.

0
votes

Maybe this can be a workaround.

screenshot of dataflow:

enter image description here

1.create two source in dataflow,range of first source:A1:A5,another:C1:C5(row num should be same)

2.create two SurrogateKey,give the key column,and start value should be same.

3.create join,setting like below: enter image description here

4.create select,delete the column you don't need(sk),then you can do some transform or something else.

data preview: enter image description here