Forum Discussion
New Appended Query issue/question
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?
- MichaelSamiotis1 year agoResolver I
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.
- jbrines1 year agoAdvocate III
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?
- jbrines1 year agoAdvocate III
Hi MichaelSamiotis I don't think merge will work for me as I don't want the data to the side of each other I want it below it if you know what I mean.
So each query bring data from a sharepoint list each list has the same colums Name, Company, Profession etc and I want to put them in to one big table.
Maybe there is another way of doing this instead of appending and merging?
Thanks
J
- MichaelSamiotis1 year agoResolver I
Hi,
I didn;t mention merge, only appending the queries. You can do it by going to Get Data > File > SharePoint Folder
If this doesn;t work, can you please share the file to have a look?