Forum Discussion
mysql append query error
- I still do not know the main cause of this error, but the solution is once the necessary transformations are made, in the attached query change the name of the columns, then load correctly, I hope this can be useful to other people. Thank you
Hi Anonymous,
Could you please specify how did you solve this? I am having exactly the same problem.
On the other hand, this still needs to be solved, I have tried different things, append is the only problematic operation which is weird.
hi aarola
If the error you have is the same that appears in the attached screens what I did was to make the append of the tables in power query
naturally for these to be loaded if they come from different systems have to have the same column name
After they are merged correctly you change the name to the identifier of the column and it should work
apparently it is a topic related to language I suggest you look at the regional configuration of the machine
I hope to be helpfulGot it, works perfectly. Thank you so much! In my case, I just had to edit column's names of additional custom columns.
