add Multiple steps to a Power Query conditional statement

Question

I have a single step conditional statement that works

    BlanksToNull = Table.ReplaceValue(#"Trimmed Text","",null,Replacer.ReplaceValue,Table.ColumnNames(#"Trimmed Text")),
    newMergedHeader = Excel.CurrentWorkbook(){[Name="newheader"]}[Content]{0}[Column1],
    #"Merged Columns" = 
     if newMergedHeader <> null then 
      Table.CombineColumns(BlanksToNull,mergeHeaders[List Of Headers For Concatenation], each Combiner.CombineTextByDelimiter("|", QuoteStyle.None)(List.RemoveNulls(_)),"Merged"),
    else 
        BlanksToNull

 in  
  if newMergedHeader <> null then     
     #"Merged Columns"
  else  
     BlanksToNull

But if newMergedHeader <> null I also want to add this #"Renamed Columns" = Table.RenameColumns(#"Merged Columns",{{"Merged",newMergedHeader}})

Is there a way to add this to the existing If statement? or do I need to write a second If statement?

I tried

#"Merged Columns" = 
     if newMergedHeader <> null then 
      Table.CombineColumns(BlanksToNull,mergeHeaders[List Of Headers For Concatenation], each Combiner.CombineTextByDelimiter("|", QuoteStyle.None)(List.RemoveNulls(_)),"Merged"),
      #"Renamed Columns" = Table.RenameColumns(#"Merged Columns",{{"Merged",newMergedHeader}})
    else 
        BlanksToNull

But this does not work

Thanks

horseyride · Accepted Answer · 2022-05-27 16:31:59Z

2

eyeballing, looks like you have an extra comma Merged"),

If you remove that and combine your statements I think you can do

#"Merged Columns" = 
 if newMergedHeader <> null then 
    Table.RenameColumns(
          Table.CombineColumns(BlanksToNull,mergeHeaders[List Of Headers For Concatenation], each Combiner.CombineTextByDelimiter("|", QuoteStyle.None)(List.RemoveNulls(_)),"Merged")
    ,{{"Merged",newMergedHeader}})
else BlanksToNull

but it is unclear to me why you need the whole tail end of things after the in instead of just replacing

in  
  if newMergedHeader <> null then     
    #"Merged Columns"
  else  
     BlanksToNull

with

in  #"Merged Columns"

since you already did all the work

edited May 27, 2022 at 16:31

answered May 27, 2022 at 16:06

horseyride

21.8k3 gold badges15 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

xyz333 Over a year ago

Thanks that work great!. My first Power Query if statement attempt that's why the tail end things were there. I will study your post

Collectives™ on Stack Overflow

add Multiple steps to a Power Query conditional statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related