Transform Data with ADF Data Flows, Part 1: Getting Started

[@damolaakinleye101]

Thanks for providing your repo :)

[@dwainDigital]

I have a file I am reading into a blob via datafactory. Its formatted in excel. Some of the column headers have special characters and spaces which isn't good if want to take it to csv or parquet and then SQL. Is there a way to correct this in the pipeline using dataflows? Example "Activations in last 15 seconds high+Low" "first entry speed (serial T/a)"

[@MSDataFactory]

You can add a data flow source that is the excel file and then modify the column headers using a Select transformation

[@junaidmalik9593]

Very helpful thanks so much :)

[@parthpatwardhan3450]

Bro In your radio file data while performing the timeestamp column is coming entirely NULL

[@dheerajlenka2607]

Can we get the data set, so that we can do hands on?

[@stevehopper8086]

yes please

[@MSDataFactory]

The sample data file being used in this demo is moviesDB.csv
github.com/kromerm/adfdataflowdocs/tree/master/sampledata

[@MSDataFactory]

The sample data file being used in this demo is moviesDB.csv
github.com/kromerm/adfdataflowdocs/tree/master/sampledata

[@Mrshivalg]

Please share the dataset link, i want to do hands on , thanks

[@MSDataFactory]

The sample data file being used in this demo is moviesDB.csv
github.com/kromerm/adfdataflowdocs/tree/master/sampledata

[@harryting3627]

@@MSDataFactory In this video, your source file is small_radio_json.json, not moviesDB.csv. Can you provide the link to download small_radio_json.json file? Thanks.

[@MSDataFactory]

@@harryting3627 Sorry about that! It's now available here: github.com/kromerm/adfdataflowdocs/blob/master/sampledata/small_radio_json.json

[@harryting3627]

@@MSDataFactory Thanks!