Log In
Register
Home
New Member
June 24, 2016
Offline
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!
November 8, 2013
Offline
Hi,
Can you share your query?
July 16, 2010
Offline
Hi,
It sounds like your final query is included in the append?
Mynda
February 18, 2015
Offline
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.
Active Member
November 10, 2018
Offline
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?
VIP
Trusted Members
December 7, 2016
Offline
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
Offline
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
Active Member
November 10, 2018
Offline
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
July 16, 2010
Offline
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)
