1 2 3 4 5 6 7 8 9 10
|
let
Source = Excel.CurrentWorkbook(){[Name="Tableau1"]}[Content],
TypeModif = Table.TransformColumnTypes(Source,{{"Famille", type text}, {"Ref", type text}}),
RequêteFusion = Table.NestedJoin(TypeModif,{"Famille"},Cle,{"Famille"},"Cle",JoinKind.LeftOuter),
DecodeurImport = Table.ExpandTableColumn(RequêteFusion, "Cle", {"Decodeur 1"}, {"Cle.Decodeur 1"}),
CleConfig = Table.AddColumn(DecodeurImport, "Personnalisé", each Expression.Evaluate([Cle.Decodeur 1], Record.Combine({[_=_], #shared}))),
SupCol = Table.RemoveColumns(CleConfig,{"Cle.Decodeur 1"})
in
SupCol |
Partager