cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Excel Middleware filter syntax

Jump to solution

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.

 

Abu_2-1600230932063.png

 

Abu_1-1600230901798.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

 

 

 

Labels: (1)
Tags (2)
0 Kudos
Reply
4 Replies
Highlighted
Nintex Employee
Nintex Employee

Re: Excel Middleware filter syntax

Jump to solution

@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_0-1600236172492.png

 

leighburke_0-1600236049143.png

 

View solution in original post

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Excel Middleware filter syntax

Jump to solution

@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?

 

Abu_0-1600250911871.png

Thanks.

Abu

 

0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: Excel Middleware filter syntax

Jump to solution
0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Excel Middleware filter syntax

Jump to solution
Thanks a lot.
0 Kudos
Reply