Help please Chapter 05-05

Juan
Book Q&A › Category: Chapter 5 › Help please Chapter 05-05
0
Vote Up
Vote Down
Juan asked 3 years ago

let

Origen = Excel.Workbook(File.Contents("C:DataC05C05E05 – Products.xlsx"), null, true),

"Otras columnas quitadas" = Table.SelectColumns(Origen,{"Data"}),

#"Personalizada agregada" = Table.AddColumn(#"Otras columnas quitadas", "Parent Category", each [Data][Column1]{1}),
#"Personalizada agregada1" = Table.AddColumn(#"Personalizada agregada", "Personalizado", each Table.AddColumn([Data], "Column7", each [Data][Column1]{1})),
#"Otras columnas quitadas1" = Table.SelectColumns(#"Personalizada agregada1",{"Parent Category", "Personalizado"}),
#"Se expandió Personalizado" = Table.ExpandTableColumn(#"Otras columnas quitadas1", "Personalizado", {"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7"}, {"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7"})

in

"Se expandió Personalizado"

Attachments
Chapter-05-05-Solution1.txt

1 Answers
0
Vote Up
Vote Down
Gil Raviv Staff answered 3 years ago

Hi Juan,

Sorry for the late response. I was able to run your code that was attached. The Q&A plug0in may manipulate the M code. You are welcome to contact me by email at gilra@datachant.com.

Here is the code that worked on my computer (You may see it with modifications here):

let

Origen = Excel.Workbook(File.Contents("C:DataC05C05E05 – Products.xlsx"), null, true),

"Otras columnas quitadas" = Table.SelectColumns(Origen,{"Data"}),

#"Personalizada agregada" = Table.AddColumn(#"Otras columnas quitadas", "Parent Category", each [Data][Column1]{1}),
#"Personalizada agregada1" = Table.AddColumn(#"Personalizada agregada", "Personalizado", each Table.PromoteHeaders(Table.RemoveFirstN([Data], List.PositionOf([Data][Column1],"Name")))),
#"Otras columnas quitadas1" = Table.SelectColumns(#"Personalizada agregada1",{"Parent Category", "Personalizado"}),
#"Res" = Table.ExpandTableColumn(#"Otras columnas quitadas1", "Personalizado", {"Name", "ProductNumber", "Color", "StandardCost", "ListPrice", "Size"}, {"Name", "ProductNumber", "Color", "StandardCost", "ListPrice", "Size"})

in

"Res"