Forum Discussion

OSS's avatar
OSS
Helper III
7 years ago

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...
Need Help
OSS's avatar
OSS
Helper III
7 years ago

Dear Greg. Thank you for response.

 

I have 12 separate queries (12 excel uploads). I have appended them and get 1 one Yearly sales table with 12 amount columns. Then I have created new 'Grand Total' column and add up all these 12 monthes sales. Now I want to pivot my results related to this new 'Grand Total' column. Your solutions is good, but it works for native query columns. The columns which are added out of query editor will not be found in query ediyor window.

tex628's avatar
tex628
Community Champion
7 years ago

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.

  • OSS's avatar
    OSS
    Helper III
    7 years ago

    Actually I don't need any date for my queries. Before uploading I correct all my tables and make all columns the same name.