SOQL row replication to Excel duplication

  • 24 September 2019
  • 2 replies
  • 5 views

I have a fairly straightforward SOQL query to pull Opportunity Line Items:
select Id, Quantity, UnitPrice, TotalPrice from OpportunityLineItem where OpportunityId='<<Opportunity_Id>>'

I tagged an Excel doc and it works fine to pull in the information from the first row.  When I add row replication though, on the output everything is repeated twice.  This happens regardless of whether there is only one opportunity line item or multiple line items - basically the results from the query get pasted in twice.

Any ideas on what I'm doing wrong?


2 replies

Userlevel 5
Badge +13

Hi,


 


If you run the SOQL in the developer console and replace the tag with the id of the record you used for testing, do you get the same result? If you provide the template I can check and see if it all looks correct. Alternatively if you contact the support team, they will be able to have a look remotely for you and tell you what the issue is.

I don't get any duplicates in the developer console, I'll submit a support request and see what they say.

Reply