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

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

  • MichaelSamiotis's avatar
    MichaelSamiotis
    Resolver I
    1 year ago

    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?

    • jbrines's avatar
      jbrines
      Advocate III
      1 year ago

      Hi MichaelSamiotis Is it fine to share on here or can I share it another way?

      • MichaelSamiotis's avatar
        MichaelSamiotis
        Resolver I
        1 year ago

        Hi, just sent you a PM.