Forum Discussion
New Appended Query issue/question
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.
- 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?
- jbrines1 year agoAdvocate III
Hi MichaelSamiotis Is it fine to share on here or can I share it another way?