Forum Discussion
rlansing
Resolver I
Resolver IPower 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. ...
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)),
pqian
Microsoft Employee
Microsoft EmployeeYour 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)),
- rlansing
Nice! Thank you!
