Forum Discussion

rlansing's avatar
rlansing
Resolver I
10 years ago
Solved

Power Query Steps are not being applied

Hello, I am attempting to append multiple tables in power query. They are worksheets from the same workbook, so if there is a better way to append all the worksheets from a workbook, I am all ears. ...
  • pqian's avatar
    10 years ago

    Your Output step is still referencing Source:

    Output = Table.AddColumn(Source, "Brand", each ReplacementFunction([BRAND DESCRIPTION], 0)),

     

    You probably meant

    Output = Table.AddColumn(#"Appended Query", "Brand", each ReplacementFunction([BRAND DESCRIPTION], 0)),