Forum Discussion

GW999's avatar
GW999
Frequent Visitor
5 years ago
Solved

Skip first row of CSV file before processing

Hi all,   I've found a bunch of people with similar queries to mine but not quite the same and I'm stuck. I currently have a query that imports data from multiple CSV files sat on Azure Blob storag...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi GW999 

    Try this on the AddFileContentsAsColumn step

    AddFileContentsAsColumn = Table.AddColumn(#"folder1", "Custom", each Table.PromoteHeaders(Table.Skip(Csv.Document([Content],[Delimiter=",", Encoding=1252]),1)))

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

  • AlB's avatar
    AlB
    5 years ago

    GW999 

    Try specifying the number of columns in the second argument of Csv.Document(). Instead of the current

               [Delimiter=",", Encoding=1252]

    try

          [Delimiter=",", Columns = 2, Encoding=1252]

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

     

GW999's avatar
GW999
Frequent Visitor
5 years ago

That “#"folder1" = Source{[Name="folder"]}[Data],” step appears as ‘navigation’ in the Applied Steps list:




And the table looks like this:

 

Then we have:



Resulting in:



And then:



This is with the “Table.Skip” modification in place – Date is good but Values are all null: