Forum Discussion
Appended queries optimization
Dear all I have 12 sales tables. (Sales by monthes) Columns are: customer id, product id and amount. I append all 12 tables (queries) and get final result with more than 5 million rows. Could y...
Add a date column to each query with the appropriate month and make sure that the other columns all have the same name ( Amount, Product, Customer). Then append the 12 queries and you should be able to show the values by dimension.
Actually I don't need any date for my queries. Before uploading I correct all my tables and make all columns the same name.