Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Problem with merged Queries

Hello Team,

 

I have two excel files. rows count in first file is 95,400 and in second file count is 68,000. after merging the second file into first all my measures are showing errors. all my count / aggregate formulas are showing (Blank). i have checked all the data types are correct and no errors in queries. 

i have merged two files in one and the total rows increased by 163,400. that might be a reason why i am getting Blank ?

 

Please help me with the issue 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Seem like many too many join between 2 tables , that is why rows are increasing

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello Amit,

       

      Thanks for your reply!!

       

      No, simply one to many relationship b/w date table & the second table.

  • jaideepnema's avatar
    jaideepnema
    Solution Sage
    4 years ago

    Hi Anonymous ,

    I think its because of one to many relationship while merging the row count is increasing in the final dataset because against a single row in table one you are getting multiple rows in table 2 while joining/merging the two tables together.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    What kind of Join Kind did you use? I think you won't get total rows more than left one (95400) or Right one (68000). You get 163400 = 95400 + 68000, It looks like that you are trying to use Append function.

    For reference: Combine queries

    If this reply still couldn't help you solve your problem, please share a sample file with us and show us a screenshot with the result you want. This will make us easier to find the solution.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.