Append queries with condition

Power Query

Last Post by jaryszek 4 years ago

4 Posts

2 Users

0 Reactions

31 Views

RSS

jaryszek

(@jaryszek)

Posts: 177

Reputable Member

Topic starter

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

Posted : 18/05/2021 5:39 am

jaryszek

(@jaryszek)

Posts: 177

Reputable Member

Topic starter

Anyone please help,

Jacek

Posted : 19/05/2021 1:34 am

Catalin Bombea

(@catalinb)

Posts: 1937

Member Admin

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"

Posted : 19/05/2021 2:18 am

jaryszek

(@jaryszek)

Posts: 177

Reputable Member

Topic starter

Thank you so much,

let me try 🙂

Best,
Jacek

Posted : 19/05/2021 5:07 am