Forum Discussion

jbrines's avatar
jbrines
Advocate III
1 year ago

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. ...
Need Help
MichaelSamiotis's avatar
MichaelSamiotis
Resolver I
1 year ago

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.

jbrines's avatar
jbrines
Advocate III
1 year ago

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?