SOLVED
Home

Combining Tables

%3CLINGO-SUB%20id%3D%22lingo-sub-769954%22%20slang%3D%22en-US%22%3ECombining%20Tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769954%22%20slang%3D%22en-US%22%3E%3CP%3EIssue%3A%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20get%20two%20tables%20instead%20of%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20the%20queries%20and%20connections%20I%20have%20loaded%20in%20two%20tables%20with%20the%20same%20column%20names.%20I%20can't%20figure%20out%20how%20to%20get%20the%20two%20tables%20with%20identical%20column%20names%20to%20be%20just%20a%20singular%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20an%20image%20of%20what%20I%20have.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124193i09DE3684E027CCAC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Captured.PNG%22%20title%3D%22Captured.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20do%20not%20want%20the%20second%20column%20headers%20to%20appear.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-769954%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-770003%22%20slang%3D%22en-US%22%3ERe%3A%20Combining%20Tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-770003%22%20slang%3D%22en-US%22%3ELook%20at%20Data%20tab%2C%20Get%20Data%20button%2C%20Combine%20Queries%2C%20Append.%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Issue:  

I get two tables instead of one.

 

Using the queries and connections I have loaded in two tables with the same column names. I can't figure out how to get the two tables with identical column names to be just a singular table.

 

Here is an image of what I have. 

Captured.PNG

I do not want the second column headers to appear. 

 

Thanks for the help!

 

 

1 Reply
Solution
Look at Data tab, Get Data button, Combine Queries, Append.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies