hi Guys,
i added boolean parameter from table like here:
SourceTable:
TopologyTierNumber
| Topo2 | Tier2 | 1 |
| Topo2 | Tier2 | 2 |
| Topo2 | Tier2 | 2 |
Boolean table:
TopologyTierIsIncluded
| Topo1 | Tier1 | TRUE |
And now i want to append 2 tables based on condition th get result (If TRUE):
TopologyTierNumber
| Topo2 | Tier2 | 1 |
| Topo2 | Tier2 | 2 |
| Topo1 | Tier1 |
If FALSE:
TopologyTierNumber
| Topo2 | Tier2 | 1 |
| Topo2 | Tier2 | 2 |
Can you please advice how M language should look like for it?:
Best,
Jacek
Anyone please help,
Jacek
let
Source = Excel.CurrentWorkbook(){[Name="SourceTable"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Topology", type text}, {"Tier", type text}, {"Number", Int64.Type}}),
#"Removed Duplicates" = Table.Distinct(#"Changed Type"),
Custom1 = if IsAppended[IsIncluded]{0}=true then Table.Combine({#"Removed Duplicates",IsAppended}) else #"Removed Duplicates",
#"Removed Columns" = Table.RemoveColumns(Custom1,{"IsIncluded"})
in
#"Removed Columns"
IsAppended should be:
let
Source = Excel.CurrentWorkbook(){[Name="IsAppended"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"IsIncluded", type logical}})
in
#"Changed Type"
Thank you so much,
let me try 🙂
Best,
Jacek
