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

  • 8 July 2019
  • 1 reply
  • 6 views

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


1 reply

Userlevel 4
Badge +8

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

Reply