adding lookup in query ending with incorrect result

[abdul]

i am getting two diffrent results in total. query1 is providing acurate result. 

query2 as soom as adding |lookup locationdetails.csv City AS City total value to less than acurate one
using splunk version 7.3.71

query1
index=xyz source=xyz 
|eval Month=strftime(_time,"%b %Y")
|search Month="Mar 2021"
|search Product In (Sold,Damaged)
|stats count(Product) as Total 

query 2
index=xyz source=xyz 
|eval Month=strftime(_time,"%b %Y")
|search Month="Mar 2021"
|search Product in (Sold,Damaged)
|lookup locationdetails.csv City AS City
|stats count(Product) as Total 

[bowesmana]

What are the fields in the lookup file?

[PickleRick]

Seems strange indeed. Are you sure that your lookup doesn't overwrite Product field somehow? (you're not specifying output fields)