Unable to skip rows for the files read from ADLS Gen 2 RRS feed

  • Question

  • Dear Team,

    I am unable to skip few rows from a source file which is available from ADLS Gen2. I see a property to check First Row as Header. I don't see a property to skip rows. I see in the column delimiter as Start of heading (\u0001). But this is not working in the preview mode when I change the values. 

    Any help on this topic is much appreciated.

    Thanks and Regards,


    Friday, October 4, 2019 3:22 PM

All replies

  • This is specifically for the copy activity in Azure Data Factory. 

    If the source is specified as a Delimited Text Dataset, the number of lines skipped can be determined using the 'Skip Line Count' property. 

    In the documentation it mentions how this property works: 

    The following picture shows where in the Azure Data Factory UI this property can be set:

    Friday, October 4, 2019 5:08 PM