Forum Discussion

louzensf's avatar
louzensf
New Member
2 years ago

Circular reference or not?

Hi everyone, I have recently adjusted one of my reports - one of our customers stopped sending us EAN for old products. I adjusted the queries and now it searches by name of the product in one of ...
Need Help
Kishore_KVN's avatar
Kishore_KVN
Solution Sage
2 years ago

Hello louzensf your requirement is bit confusing. Can you explain again with an example please. 

 

 

louzensf's avatar
louzensf
New Member
2 years ago

Hi Kishore_KVN , thanks for answering,

I have used merge to fill in some '?' we are getting instead of EANs, with the use of one of our old files. Now the refresh loads way more data than it should and from 9 minute refresh I got to 2hr+ and it still didn't finish. 

I figured that maybe this is a problem with merge function? I can simply Xlookup the ? in the excel, but I need the reports to be as automatic as possble. 

Thanks!