Forum Discussion
New Appended Query issue/question
Hi Guys, I have created a new appended query that has over 30 queries in it. With the new appended query named "All Data" I then start using commands like Trim, Change Type and Sorting Rows. ...
Hi MichaelSamiotis clearing cache didn't resolve it.
Any articles on how to use refreencing?
Thanks
J
Have a look on that one please: https://support.microsoft.com/en-gb/office/combine-multiple-queries-power-query-16b1421c-9708-466a-8d6e-30a324949722
Hi MichaelSamiotis so basically referencing is merging?
Exactly. Another thing to try if this doesn't work is to remove any extra steps from your individual tables before appending. All the transformation steps should be on the final query.
I only have a few steps in each query and they all have the same steps. See below.
#"Replaced Value" = Table.ReplaceValue(#"Expanded value",null,"CE4079",Replacer.ReplaceValue,{"value.Contract"}), #"Changed Type" = Table.TransformColumnTypes(#"Replaced Value",{{"value.Modified", type datetime}, {"value.Created", type datetime}, {"value.SignInDateandTime", type datetime}, {"value.SignOutDateandTime", type datetime}}), #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"value.Title", "Name"}, {"value.Modified", "Modified"}, {"value.Created", "Created"}, {"value.Company", "Company"}, {"value.SignInDateandTime", "Sign In Date and Time"}, {"value.SignOutDateandTime", "Sign Out Date and Time"}, {"value.Profession", "Profession"}, {"value.SignInLocation", "Sign In Location"}, {"value.SignOutLocation", "Sign Out Location"}, {"value.ModeofTransport", "Mode of Transport"}, {"value.AreyouaDriver_x002f_Passenger", "Are you a Driver or Passenger"}, {"value.PostcodeStart", "Postcode Start"}, {"value.ProjectPostcode", "Project Postcode"}, {"value.Distance_x0028_includingreturnjo", "Distance includingr eturn journey"}, {"value.Contract", "Contract"}}), #"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"Skip"}), #"Renamed Columns1" = Table.RenameColumns(#"Removed Columns",{{"Distance includingr eturn journey", "Distance including return journey"}, {"value.Created_x0020_Date0", "Created Date"}, {"value.Created_x0020_Time", "Created Time"}, {"value.Modified_x0020_Time", "Modified Time"}, {"value.Sign_x0020_Out_x0020_Time", "Sign Out Time"}, {"value.Hours", "Hours"}})Would it be OK to keep them in?