Forum Discussion
rlansing
10 years agoResolver I
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. ...
- 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)),
pqian
10 years agoMicrosoft Employee
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)),
- rlansing10 years agoResolver I
Nice! Thank you!