Hi,

Can you share your query?

Hi,

It sounds like your final query is included in the append?

Mynda

If you have multiple sheets and multiple named tables, it might happen that you add the data twice - once from the table and once from the sheet.

I have almost the same problem.

I append 2 files that contain only 1 sheet. but the values doubled after I appended. Anyone have an idea on this?

Hi Dorothy,

It is always easier to give help if there is a file attached, so we can see the data.
You don't have to have the real data in, just some sample data is good enough to visualize the problem.

My experience with appending data and you get doubles, it is because there are two or more exact data rows from the different sources.

But if this is the case for you or not is hard to tell without a file to check.

Br,
Anders

Hi Dorothy,

I suspect the query is getting data from all tables/sheets in the files. You're probably then loading your query into a sheet/table in the same file, it's then getting loaded into Power Query again. This is usually the culprit. If that's not it, please share your file or queries so we can take a closer look.

In future, please start a new thread with your question and sample file.

Thanks,

Mynda

Hi Mynda,

I think you're right. How can I fix this if both files are being loaded? I just need the appended one.

Thanks,

Dorothy

Hi Dorothy,

Edit the query and after the 'Source' step and add a filter that excludes the name of your query table. Just select the Source step, then apply a filter. It will ask you if you want to insert a step.

I usually try to name my query table something distinctly different to the names of my source data table for this very reason.

Mynda

Hi everyone, I tried every advise you said but still it doesn't work. What I did as workaround was remove the append of the two files then hit load. That seem worked.