Sen Zhang

Dynamic Column in Azure Data Factory Flow

Based on the requirement, we need load source data into Landing Table, using Azure Data Factory.

source file and database table

primary key is deviceId, day 1’s value need mapping to column Mon. day 2’s value need mapping to column Tue, and so on.

my data flow is:

link source to the txt file.

--

--