XLSX:
Step10 = Table.SelectRows(#"Filtered rows 1", each [Extension] = ".xlsx"),
Step11 = Table.SelectColumns(Step10, {"Content", "Name"}),
Step12 = Step11{0}[Content],
Step13 = Excel.Workbook(Step12, null, true),
Step14 = Table.SelectColumns(Step13, {"Name", "Data"}),
CSV:
Step03 = Table.SelectColumns(Step01, {"Content"}),
step04 = Table.AddColumn(Step03, "Cols", each Csv.Document(([Content]),[Delimiter=";", Columns=50, Encoding=65001, QuoteStyle=QuoteStyle.None])),
step06 = Table.RemoveColumns(step04, {"Content"}),
No comments:
Post a Comment