Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Tengo dos tablas de la siguiente manera:
Cust
| costar | Suppo |
| 7 | a |
| 7 | b |
| 8 | a |
Supp
| Suppo |
| a |
| b |
| c |
Quiero que el objeto visual de tabla/matriz sea el siguiente:
t1 =
| costar | Suppo |
| 7 | a |
| 7 | b |
| 8 | a |
t2 =
| costar | Suppo |
| 7 | c |
| 8 | b |
| 8 | c |
Ambas tablas están relacionadas por la columna suppo. ¿Cómo puedo crear un objeto visual t2?
Consulta T2:
let
Source = Table.SelectColumns(t1,{"custo"}),
#"Removed Duplicates" = Table.Distinct(Source),
#"Added Custom" = Table.AddColumn(#"Removed Duplicates", "Custom", each Supp),
#"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Suppo"}, {"Suppo"}),
#"Merged Queries" = Table.NestedJoin(#"Expanded Custom", {"custo", "Suppo"}, t1, {"custo", "suppo"}, "t1", JoinKind.LeftAnti),
#"Removed Other Columns" = Table.SelectColumns(#"Merged Queries",{"custo", "Suppo"})
in
#"Removed Other Columns"