Solved

Excel Middleware filter syntax

  • 16 September 2020
  • 4 replies
  • 18 views

Hi All,

I am trying to pull data into my DDP (word template) conditionally based on Account number from an excel sheet. If an Account number (column A) in the spreadsheet matches with the one on Opportunity record then it should pull that row only. Can someone please help me with the filter criteria or how i can acheive this, i have been struggling since past few days with this.

 

8955i3F4721B72B8AC6AB.png

 

8954iC64C4166B016635D.png

Example output to acheive

Majik AccountNo Tuesday Thursday Friday Saturday Sunday
PE001007 I 67/I 68/I 69/I 70/IA 67/IB 67 I 67/I 68/I 69/I 70/IA 67/IB 67 I 67/I 68/I 69/I 70/IA 67/IB 67 I 67/I 68/I 69/I 70/IA 67/IB 67 I 67/I 68/I 69/I 70/IA 67/IB 67

 

Many Thanks.

Abu

 

 

 

icon

Best answer by leighburke 16 September 2020, 08:01

View original

4 replies

Userlevel 5
Badge +13

@Abu the filter field on that page is actually for use with Salesforce reports. To do what you are looking for I would have another sheet where you have field being pulled into the excel from Salesforce and use vlookups to grab the data from the correct row on your sheet holding the data. You can then use that sheet as the one being pulled in to the word document.



 



 

@leighburke , that worked perfectly!! Thanks a ton.


Quick question, do i also need to add the excelsheet into the middle section of the DDP as it works fine by just linking the template to the spreadsheet. Would there be any issues by not doing so?


 



Thanks.


Abu


 

Userlevel 5
Badge +13

@Abu I would add it in the middle like shown in the help(https://help.nintex.com/en-US/docgen/docservices/#docgen-sfdc/Services/templates/ExcelMiddleware.htm)

Thanks a lot.

Reply