
New Member

June 24, 2016

I have an Excel file with 20+tabs that contain the same workbook for different accounts. I have created named tables for each account and loaded in PQ via "from table" creating connections only. When I append the data to load into one query all my data is duplicated. How can I avoid this? I will be revising these tables often, and can manually delete the duplicates from the query, however know I must be doing something wrong. Any suggestions appreciated!

VIP

Trusted Members

December 7, 2016

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


July 16, 2010

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


July 16, 2010

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
1 Guest(s)
