This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have ~10 excel tables with varying columns, My aim is to connect sources based on a few common fields
What is the best method to do this? Im not having too much success with Join Multiple
so lets say I have
If Name and Location match on say 1 and 3 I get:
Join multiple should work.
Here's a sample.
P.S. The join function is case sensitive.
The join multiple doesnt seem to work in the case required.
I.e. if 2 data sources have name and colour and weight
then another has name and weight
then another has weight and colour
how to combine these, if not the same fields on all 3?