none
Using "From Table" causes data refresh to not be correct RRS feed

  • Question

  • I have a data model with 23 queries ...  except for the queries that load data from an outside source each subsequent query depends on the preceding query ..

    Example:

    First data set

    Query - 1 - from file - number of rows = 1,000

    Query - 2 - from file - number of rows = 2,000

    Query - 3 - Query 1 & 2 merged - number of rows = 3,000

    Query - 4 - "From Table - Query 3" - includes "Filter - 1" based on Column "A" - number of rows = 500

    Query - 5 - "From Table - Query 3" - includes "Filter - 2" based on Column "A" - number of rows = 2,500

    Query - 6 - Merge Query 4 & Query 5  - number of rows = 3,000

    etc....

    New data set

    Query - 1 - from file - number of rows = 2,000

    Query - 2 - from file - number of rows = 3,000

    Query - 3 - Query 1 & 2 merged - number of rows = 5,000

    Query - 4 - "From Table - Query 3" - includes "Filter - 1" based on Column "A" - number of rows = 500

    Query - 5 - "From Table - Query 3" - includes "Filter - 2" based on Column "A" - number of rows = 2,500

    Query - 6 - Merge Query 4 & Query 5  - number of rows = 3,000

    etc....

    When I run "Refresh All" Queries 4 and 5 calculate before Query 3 with the 'old values' ... result is Query 6 is wrong ...

    How do I manage the calculation order??

    Thank you ...

    Steve

    Friday, April 22, 2016 5:25 PM

Answers

All replies