Problem with merged Queries

[Anonymous]

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 

[Anonymous]

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.

[jaideepnema]

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.

[amitchandak]

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

[Anonymous]

Hello Amit,

Thanks for your reply!!

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