Tuesday, September 8, 2020

Power Query - Converter CSV / XLSX

 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

Power BI APP - Delete or Unpublish

 UNPUBLISH DELETE