Hi ,
Is there any way to concatenate the values available in multiple row of a given column using Multi row formula expression .
Thanks
Here is the expectation :
@Nandakishore
Hi @binu_acs ,
Thankyou .Just a small change . Can you help to arrive the result based on uniqid as shown :
@Nandakishore I updated both my workflows, i was using a wrong field iin the initial workflow
Thanks again . I applied below formula in the tool :
IIF(isNull([Row-1:Uniqud]) AND isNull([Row+1:Uniqud]),[DType],IIF(isNull([Row+1:Uniqud]),[Row-1:output],(toString([DType])+toString([Row+1:DType]))))
and the result is :
But i need like this :
Do you have to use the multi-row formula tool? This would be much easier using a summarise tool. Group and concatenate the values you want (removing separators from the concatenation) then join back on to the original data.
@Christina_H ,
When i join back the line duplicate hence multi row formula
Obviously you can use whichever tools you like, but you shouldn't get duplication joining back the summarised data, see my output above.
thankyou . I like to see this with multi row formula .
Here's a few different options, using either summarise or multi-row formula. I've applied the same methods to two different sets of data you provided. They should all continue working if there are more rows with the same unique ID.
Hi @Christina_H and @binu_acs ,
Thankyou for the help . But it does not work with Multi row formula .
@binu_acs , you logic for only for 2-3 rows . Can you help to do the same for any number of row .
Thanks.
@Nandakishore if you have more rows you need to adjust the multi-row tool num or rows and the expression
Using that method in the multi-row formula, it will never work for any number of rows. The formula has to explicitly include each row. There has to be a maximum number it will work for, which is the number you've included in the formula.
Can you show what your results are so we can figure out what isn't working?
