Forum Discussion
Combine data from 3 different spreadsheets
You can combine the 3 tables by using a union. Go to the modelling tab, select new table and enter the logic below (the table names will need updating to what you have called them):
Combined Table = UNION(Table 1,Table 2,Table 3)
Please use the link below to learn more about the UNION function:
Do you get a blank result when you union the table giving you the issue with the others separately?:
Combined Table Test 1 = UNION(APAC,Americas)
Combined Table Test 2 = UNION(EMEA,Americas)
A case of 2 steps forward 1 step back. Why I couldn't see the data in the Americas table was because there were thousands of blank rows. I deleted them and all seems OK. The issue is now as follows.
In order to create the union, I use data transform to delete some columns and move others about. When I look at the columns in transform I have the same number of columns in the same order in each table. When I perform the union it seems to forget the order that I put the columns in and I get a mix of data in each column. If I can just fix this I am all good. Any further suggestions?