Power Query combine

Question

Hi, I am using power query to combine daily data. I put data as same structure to folder and combine it. The problem is that in data set i have additional columns which are added manually. The problem i experienced is that new data is merging and i would like to have the same procces (putting data files into folder) but instead of merging data i would like to concatenate it, because now merging new data is overwriting additional columns in dataset. Can u use combine w/ append/concatenate function instead of merge?

Answer 1

Yes, you can append table queries.