Forum Discussion
Skip first row of CSV file before processing
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
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
Community ChampionThat doesn't look like the raw file. It's already in table format. 🤔
In any case, if it loads like that with Csv.Document( ) then wat we did earlier should work fine
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
Here you go, opened in Notepad instead of Excel:
01 - Teams on XXXXXXX Gateway [XXXXXXXXX],
Date,Values
14/12/2020 05:30,0
14/12/2020 05:25,0
14/12/2020 05:20,0
14/12/2020 05:15,0
14/12/2020 05:10,0
14/12/2020 05:05,0