Believe that some concepts are missing in your questions when you append data you combine tables one after the other so a single table grows on number of lines, when you merge tables then you have the possibilitie of expanding columns.
Or are you appending tables that have expandable columns and you are only expanding them after the append?
Did I answer your question? Mark my post as a solution!
i took several lists that all have the exact same columns and have a column called fieldastextvalue that is expandable and appended them, and expanded the column
for a few weeks this worked no problems and now the exapnded columns show error and i cannot redo and append the lists again and have that field that expands. so if i take the exact same lists and try it again it doesnt work, wondering if there was an update that changed this or if there is a work around to expanding those columns
the queries that i am appending are workflow task lists form 30 different sites and lists
i am not sure what the error is, but it looks like if i have an empty task list it causes an error through out the entire thing, this didnt happen a few weeks ago so microsoft might have updated something,
there isn’t any code to go over, the columns can be expanded if I only append lists that contain information not just a blank list with column headers.
basically, the lists with information in them can be expanded before and after appending them, but as soon as I append a list into the mix that doesn’t contain any information all of the other data for any expanded columns just says error,
if I remove the lists that do not contain any information then the columns become expandable again.
when I originally published this report to the online the lists that currently do not contain information did not cause any errors, but now if I try and do it then there is an error, so I am wondering if there was an update in august some time that is causing this