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