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

Dynamically pull data from excel based on unique field

Hi All,

I am trying to pull data dynamically into my word docgen template from an external spreadsheet (static) based on unique Account Number field. The Account N.o field is on my opportunity object which i have tagged my template (Opportunity_AccountNo). Now there is also a second piece of data in an external spreadsheet from which i need to pull column B (permitted use) based on the above account number which is column A of spread sheet (Account Number). How can i pull the correct data dynamically? (please see screenshots below).

 

Any help would be appreciated.

 

a) Word Template

Abu_0-1600088208810.png

b) External (static) spreadsheet

Abu_1-1600088248106.png

c) Intended Output

Abu_2-1600088773670.png

 

Thanks

Abu

 

 

Labels: (2)
0 Kudos
Reply
2 Replies
Highlighted
Nintex Newbie

Re: Dynamically pull data from excel based on unique field

Hi Abu,

 

 

Is the Account Number on the excel part of the static data, or it needs to be dynamically populated too?

You may try it this way. Assign a table range on the excel sheet.

On the word template conditionally iterate that excel table based on the account number on the excel with the account number that's pulled in from the field tagger.

 

Thanks,

Safiya

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Dynamically pull data from excel based on unique field

Thanks Safiya,

 

I actually created a new sheet in the workbook and tagged a cell (Opportunity_Account) via field tagger. Then i pulled values via vlookup from the first sheet. Finally created a tag one the result and tagged my word doc.  

 

Thanks for your help.

 

Abu

0 Kudos
Reply