Forum Discussion
ID Issue Appending Multiple Sharepoint Queries
Hello, I'm running into issues bringing in data from multiple Sharepoint lists into an appended table. It seems to choke a bit on the ID columns (which I obviously have no control over in Sharepo...
I take it that you need the ID column for some reason? Can you just not import it and add an ID column in the query? What if you create a calculated column in SharePoint that has a formula of, essentially =[ID] and import that column instead of ID?