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 

     

     

AlB's avatar
AlB
Community Champion
5 years ago

GW999 

I'd need to see the table resulting from the #"folder1" step in order to be able to see what is going on

let
Source = AzureStorage.Blobs("mydata"),
#"folder1" = Source{[Name="folder"]}[Data],

 

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