Importing SharePoint Lists with Similar & Different Column Names

[abrig005]

Hello, I have 5 SharePoint lists. Some with common column names and some with unique column names.
They are related by the column called Unit Name. Is there a way to merge the liss into one table so I can query based on unit name?

Thank you!

 

[Joe4]

You can combine the result of different tables into a single query by doing a Union Query (see: https://support.office.com/en-us/ar...e-result-1f772ec0-cc73-474d-ab10-ad0a75541c6e).

It might look something like this when done:

SELECT unit_name
FROM Table1
UNION
SELECT unit_name
FROM Table2
UNION
SELECT unit_name
FROM Table3;

 

[abrig005]

I will give it a shot. thank you!

 

[abrig005]

I don think union will work. "The select queries you combine in a union query need to have the same number of output fields, in the same order, and with the same or compatible data types. When you run a union query, data from each set of corresponding fields is combined into one output field so that the query output has the same number of fields as each of the SELECT statements."
My data has a different # of fields in each worksheet and not all the fields match.

 

[Joe4]

You don't need to return all the fields from each table, just the ones you need or want.
Like in my example, I am only returning the unit_name field from each table.
Ideally, that is what you would want to do. Anything that you want to return from each table in this one query should should be of the same data type.
If it is not, it sounds like you have some serious data issues. It can be very difficult to work with bad data or bad design. It makes things much harder than they need to be.