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 

With that file I get the right results with the code above. Values are 0, not null. Without access to the actual file, or one with dummy data that reproduces the issue, I'm afraid I can't do more.

 

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

Understood - thanks for the help I will play around with it and see where it's going wrong on my set.