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

Join the text in the rows to a single cell separated by comma in excel and tag to word document

Hi , I have a requirement in which I have rows of data coming from salesforce and I need to convert the column values to a single cell seperated by comma.

 

For Example: The below data should be populated as Car1, Car2, Car3, Car4, Car5 and so no..

Car1

Car2

Car3

Car4

Car5 

 

I am using excel as middleware to achieve that and using TextJoin() function which works perfectly in excel but during document generation this formula doen't calculate and give #NAME? as the value.

Can someone help me with right formula that can work in nintex? And is there any limitation on formula that can be used in excel which is used as middleware. As not all the formulaes works with nintex

Labels: (1)
0 Kudos
Reply
1 Reply
ryan_oleary
Nintex Newbie

Re: Join the text in the rows to a single cell separated by comma in excel and tag to word document

Do you have an example output with dummy data that you can attach? My suspision is that your formula is breaking when data is replicating into the document. 

 

You may need to modify your formula to be dynamic.

 

Ryan

0 Kudos
Reply