Power Query to combine multiple tables of unequal number of columns

Proud Liberal

Proud Liberal

Quite Involved in Discussions
#1
#1
NOTE TO MODERATOR: if this is posted to the wrong forum, please move it to where ever it should be.

I'm looking to combine 52 tables (weekly scrap reports from our ERP software) using PowerQuery. The column headers (see attached sample) are the scrap codes recorded during the week being reported. Therefore the number of columns in each table varies with what issues were found. I also have a summary table (with one dummy record) that has all available scrap code columns.
PowerQuery question.png
My approach was to use the summary table as the main starting point and merge the other 52 tables into that one. I've tried both Merge and Append without success.

Using Merge:
1) software wants me to "Select the same number of columns from both visible tables to continue", not practical with over 300 scrap codes in the master table (yes, that's way too many codes but that's what's in the system)
2) this process only merges two tables at a time (I've got 52)

Using Append:
1) this process will merge multiple tables but only the first four columns

I downloaded PowerQuery today and don't have any experience using it. Any advice would be highly welcomed.

NOTICE: cross-posted on MSOfficeForums and ElsmarQualityforum
 
Download Free White Paper
Elsmar Forum Sponsor
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
M Looking for medical grade wall adapter with 50Hz power transformer IEC 60601 - Medical Electrical Equipment Safety Standards Series 4
B 3'rd party mains power supply with unknown energy source level. CE Marking (Conformité Européene) / CB Scheme 3
M It is Possible to apply a wall plug power adapter to provide power from the actuators of a dialysis chair or hospital bed? IEC 60601 - Medical Electrical Equipment Safety Standards Series 1
E Transformers overload tests (subclauses 15.5.x) with switched power supplies IEC 60601 - Medical Electrical Equipment Safety Standards Series 1
ChrisM Re-labelling purchased power supply EU Medical Device Regulations 1
XRAY_3121 Class II heating pad - does the power supply have to have IEC 60601-1 testing?? US Medical Device Regulations 5
Y Is Power Switch button mandatory IEC 60601 - Medical Electrical Equipment Safety Standards Series 2
M MOPs of power socket for battery powered device IEC 60601 - Medical Electrical Equipment Safety Standards Series 0
K IEC Maximum Power Density for Muscle Stimulator IEC 60601 - Medical Electrical Equipment Safety Standards Series 0
Icy Mountain Contingency plans, Back-up Power Generation IATF 16949 - Automotive Quality Systems Standard 38
PQ Systems The Power of Pareto Charts Using SQCpack Software 0
F Configurator for a power unit - Software or other solution? Manufacturing and Related Processes 0
H Using/Selling power banks with your product as a "mobile version" CE Marking (Conformité Européene) / CB Scheme 3
S Class I Equipment with mobile power inverter IEC 60601 - Medical Electrical Equipment Safety Standards Series 0
L Class II (Double Insulated) Power Supply with Output Tied to Earth: FE or PE? IEC 60601 - Medical Electrical Equipment Safety Standards Series 4
D Hand Held medical device - power supply requirements IEC 60601 - Medical Electrical Equipment Safety Standards Series 23
A Can a power Supply be an accessory to a medical device, if it is an 'off-the-shelf' product. IEC 60601 - Medical Electrical Equipment Safety Standards Series 10
Judy Abbott The impact of laser power on biocompatibility of the products Manufacturing and Related Processes 6
C Power Supply EN60601-1 vs EN62368-1 IEC 60601 - Medical Electrical Equipment Safety Standards Series 2
S DC-AC Power inverter with two MOPPs IEC 60601 - Medical Electrical Equipment Safety Standards Series 2
J Surge Protectors and other power protection Manufacturing and Related Processes 7
Sidney Vianna Informational APQP4Wind - Advanced Product Quality Planning for the Wind Power Supply Chain APQP and PPAP 3
U Power supply - Change From 160 to 300 Watts - Significant change? EU Medical Device Regulations 2
R Power Failure or Cold Start Situation in PFMEA FMEA and Control Plans 6
R IEC 60601-1 - Power Supply Cords (Section 8.11.3.1) IEC 60601 - Medical Electrical Equipment Safety Standards Series 2
M MS Power Automate/Sharepoint Files Document Control Systems, Procedures, Forms and Templates 1
O Are power distribution units Multiple Socket Outlets (MSOs)? IEC 60601 - Medical Electrical Equipment Safety Standards Series 1
L Medical-grade power adapter labeling Other US Medical Device Regulations 2
A Calibration of Power Supplies AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
B IEC 60601 Cl. 8.4.3 - ME EQUIPMENT intended to be connected to a power source by a plug / Plug discharge IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
J Universal Power Cord with Adapters - IVD IEC 61010-2-101 CE Marking (Conformité Européene) / CB Scheme 6
L External power supplies: How close does the safety report have to match the end-use application? IEC 60601 - Medical Electrical Equipment Safety Standards Series 4
L IEC 62368-1 / Electrical Energy Source vs. Power Source? CE Marking (Conformité Européene) / CB Scheme 2
B Need For BIS Standard Mark? Imported OEM's Power supply,Li-Ion Battery Other Medical Device Regulations World-Wide 0
I Containment procedure for parts after a power outage. IATF 16949 - Automotive Quality Systems Standard 1
P UDI labeling for power module IEC 60601 - Medical Electrical Equipment Safety Standards Series 6
E IEC 61010-1 Dielectric strength test of inner power supply Other ISO and International Standards and European Regulations 0
S Power rating for medical devices in the US - Radiotherapy devices US Food and Drug Administration (FDA) 0
T Is anyone working with N299.1 (Supply/service to nuclear power plants)? Various Other Specifications, Standards, and related Requirements 0
E IEC 60335-1 power input deviation - Table 1 Values Other ISO and International Standards and European Regulations 0
H External power supply - requirements in safety/EMC test? IEC 60601 - Medical Electrical Equipment Safety Standards Series 4
K Power point training slides on DOE (Design of Experiments) Wanted Training - Internal, External, Online and Distance Learning 2
Marc Renewables, led by wind, provided more power than coal in Germany in 2018 Sustainability, Green Initiatives and Ecology 8
S Responsibilities between government owner and private subcontractor of a power plant seeking ISO 9001 certification ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
C Electrical Power Plant Supply failure in PFMEAs FMEA and Control Plans 10
H IEC 60601-1 Main Power Cord Requirement IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
M Infusion Pump Power Failure Alarm IEC 60601-2-24 IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
F Power Cord Length Issue - Medical Device Electrical Safety IEC 60601 - Medical Electrical Equipment Safety Standards Series 2
C ISO 9001:2015 - Non Applicable Design and Development (Power Plant Operator) Design and Development of Products and Processes 2
H Enclosed vs. Open-Frame Power Supplies - Overdoing it? IEC 60601 - Medical Electrical Equipment Safety Standards Series 1

Similar threads

Top Bottom